Pie Charts

[JN]

I am trying to successfully create a pie chart for each
record showing how 3 fields make the whole pie chart.
Unfortunately, I can only make it show 1 field,
literally, making the whole pie chart. The chart wizard
will only allow me to select one field as data. I am
trying to show an employee's total gross wages (wages,
vacation/holiday, and commission). I can make it update
for each record, but it only shows 100% of either wages,
vacation/holiday, or commission; which seems obsurd. It
will not show me all three fields and how they effect the
whole pie (i.e., wages: 91%, vacation/holiday 6%, and
commission 3%).

Bar charts work fine, but that is not how I prefer to
show percentages.

Thanks in advance!

JenN

 

[Fons Ponsioen]

I think the problem may be your data structure.

I you have a table with three fields, like;
Wages, Vacation, Commision,
it will not work, however if you instead would change your
data table structure to
RecordID Category Amount
Andy Vacation $5.00
Andy Wages $15.00
Andy Commission $9.00
Bert Vacation $7.00
Bert Wages $21.00
Bert Commission $3.50
The above allows for you to display the data in a pie
chart.
Hope this helps.
Fons