Populating Pie Charts

[Jarvis]

Is it possible to construct a pie chart that represents different summary fields?

I have a database that tracks components that my cabinet shop produces.

One field counts drawer boxes.

One field counts doors.

One field counts faceframes.

I also have summary fields that subtotal drawer boxes, doors and faceframes for a found set.

Is there a way to use a pie chart to demonstrate the percentage relationship between the various quantities of doors/ drawer fronts and faceframes?

In other words, can I populate a pie chart with values from more than one field?

If this is not feasible natively within FM 11 can it be done with an aftermarket plug in chart?

[comment]

In other words, can I populate a pie chart with values from more than one field?

You can populate the chart with any values - as long as they are return-separated.

[miriamg]

In other words, can I populate a pie chart with values from more than one field?

If I understand correctly, you'll want to make a chart using the 'Current Record (delimited data)' option. This allows you to specify which summary fields to compare against each other in your pie chart.

In order to do this, first change the 'Use Data From' dropdown to 'Current Record (delimited data)'.

For the Value Data you'll go to Specify Calculation and enter:

field1 & ¶ &

field2 & ¶ &

field3

For the Label Data you'll go to Specify Calculation and enter:

"label1¶label2¶label3"

[miriamg]

Here's a basic file with an example of this type of chart.

Chart using delimited data option.fp7.zip

[Jarvis]

MiriamG,

I just found this post from you.

Don't know how I missed it.

Thank you very much! Your example helped a lot.

Was even able to glean from it for a different charting question.