Pie Charts - why aren't they simple?! (1 Viewer)

[choward]

Hi guys,

i have built a query to find the sums of various fields from various tables. i want to make ONE piechart from all these the sum values... i.e.

Cars - 500
Planes - 300
Those digger things i always wanted as a kid - 200

But the stupid MSchart activex thingy in Access 2007 always wants to Sum/max/be an idiot to the data. All i want is a damn pie chart!

Any ideas?

If it can be done in VB by saying "split the piechart into 3 pieces. One = Cars, two = Planes, three = diggers" - that would be ace

 

[KenHigg]

Have you tried by-passing the wizard and set your data source in the chart object in the properties?

 

[choward]

Hi Ken,

that's what i was hoping to do but i do not know how to specify it properly.

The row/source data is the query... but how do i speficy the fields?

 

[KenHigg]

I think you need your query to end up with the simple results you use in the chart. Like:

green 34
blue 89
red 16

??

 

[choward]

Hi Ken,

turns out it was an Access 2007 bug.... GRRRR!!! It works fine once i installed Access 2007 SP1.

 

[KenHigg]

Glad you have it workin'. I'll probably get bitten by the same thing if we ever upgrade -