Pie Chart -- More than one Field/Series??

[Guest]

Can I create a pie chart based on more than one field in a record? I have a
table tracking time spent on various tasks. Applicable fields are:
AuthorTime, ResearchTime, GraphicsTime, MediaTime, and IllustTime. I also sum
these into a TotalTime field.

I tried to create a pie chart showing data from these fields (within one
record), but failed. I want one pie chart per record, displaying the amount
of time logged in each field (as a percentage of TotalTime). What I get is
one solid pie showing data for only one of the fields. The wizard will only
let me bring in one "data" element (field) for only one series.

What am I doing wrong?

 

[Duane Hookom]

It looks like your table is un-normalized. You can try graph a union query
like:
SELECT ID, AuthorTime as TimeSpent, "AuthorTime" as HowSpent
FROM tblNoNameGiven
UNION ALL
SELECT ID, ResearchTime, "ResearchTime"
FROM tblNoNameGiven
UNION ALL
SELECT ID, GraphicsTime, "GraphicsTime"
FROM tblNoNameGiven
UNION ALL
-- etc --;

You should be able to graph the above, normalized results.

 

[Guest]

Thanks Duane. Union Queries are new to me, but your reply helped me learn
how. That worked great!