B
Bill S
I am trying to create a Pie Chart where each pie piece represents the value of one field from 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 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! Thanks
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 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! Thanks