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


G

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?
 
Ad

Advertisements

D

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.
 
Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Dilemma: plotting more than one "series" 1
Pie Charts 0
pie chart 0
Pie Chart 1
Pie Chart 5
Pie Charts 2
Pie Chart 0
Pie Charts 3

Top