Please Help with Pie Chart!

[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

 

[Duane Hookom]

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