Pie chart

[masoud_sedighy]

Hi
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:

AREA		DONE		REMAIN	       TOTAL
AREA1		100		200		300
AREA2		200		300		500
AREA3		200		700		900

Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?

 

[shutzy]

my understanding of pie charts is that pie charts are not meant for this kind of data.

area 1, 100
area 2, 150
area 3, 175

not multiple values.

you might aswell number them as

area 1-xxx and have the value beside them.

you would be better off with a bar graph or a pie chart for each area.