P
Pie Charts
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
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