Please Help with Pie Chart!

  • Thread starter Thread starter Bill S
  • Start date Start date
B

Bill S

I am trying to create a Pie Chart where each pie piece
represents the value of one field from one record in a
table.

Example:

Fuel Cost Maint Cost Misc Cost

Car 1 500 1000 100
Car 2 650 500 50
Car 3 800 1200 200

I would like one pie chart per car. I would like the pie
pieces to show Fuel Cost, Maint Cost and Misc Cost for
EACH Car and show it in a report that shows this and other
data for One Car.

I have tried to use the wizard but when I show the report
I get a blue circle with a vertical line in the upper
half. When I look at the Row Source for the Chart the
Select statement only indicates one of the fields (The big
blue dot)

How can I get the chart to show all three fields and
change from record to record in a report??

I am about to go crazy with this! If it is impossible
please let me know! Thanks
 
The Row Source of your graph should be similar to
SELECT tblCars.Car, tblCars.Fuel, tblCars.Maint, tblCars.Misc FROM tblCars;
with the Car field used in link master child. Your report's record source is
tblCars.

You may need to change the Data to "Series in Rows".
 
Back
Top