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

 

[JN]

Thank you! I thought that may be the reason.

-----Original Message-----
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

.

 

[Guest]

JN
It sounds as though you were having the exact same problem that I am having now. I want to mail merge a pie chart that udates with each record in my excel spreadsheet. I couldn't figure out how to do it so I tried MS Access, which won't let me make a pie chart only a bar chart. I am trying to compare HR salary and benefit information. Did you figure out how to make it work in either word's mail merge or Access?
----- JN wrote: ----

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

Jen