Jump to content

Populating Pie Charts


Jarvis
 Share

This topic is 4307 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

  • 4 weeks later...
  • Newbies

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"

Link to comment
Share on other sites

  • 1 month later...

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.

Link to comment
Share on other sites

This topic is 4307 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.