Pie chart with values from different fields on same record

[innodat]

Does anybody know if it is possible to get a pie chart to work when pulling data from different fields on the same record, as opposed to one field across the found set?

I'm trying to get a pie chart showing

FieldA (Value 20)

FieldB (Value 30)

FieldC (Value 10)

Funny enough, it works with Bars, just not with Pie...

PS: the numbers in these fields come from different RS which count records in related tables. This is the home screen of the database with stats.

Edited June 24, 2010 by Guest

[comment]

Try =

List ( FieldA ; FieldB ; FieldC )

[innodat]

No... I tried both using the calculation in the chart set-up itself and in a (new) calc field used for the chart. Still gives me one color @ 100%.

I'm thinking there must be a way? This would be a very severe limitation.

[comment]

You must also specify a list of 3 values as Label Data.