Pie Chart on Report (SO SIMPLE BUT I'M STUCK!)

[mikebrewer]

Okay... I have the simplest thing in the world I want to do...

I have a query written that has two numbers. One is the trucking fleet size (63) and the other is the average number of trucks used over a time period (in this example, its 52.2)...

I just want to create a pie chart that has 52.2/63. so the pie would be roughly 90% filled. HOW CAN I NOT FIGURE THIS OUT???

:banghead:

 

[pbaldy]

I'm no chart expert, but I think a pie chart wants the components of the whole. Try passing the average and the difference between the average and the total (10.8 in this case).

 

[mikebrewer]

thats what I had to do. actually had to create a second table to do it. kinda goofy but it worked!