Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need help creating a very simple pie chart. How much pizza did you eat?

Featured Replies

I am new to using FileMaker's charting feature and I am having a trouble creating a very simple pie chart.

Can someone please tell me how this most basic of basic pie chart examples is done?

I have a database with a single table and a single number field: how_much_pizza_did_you_eat

If the user enters 25 I want to see 25% of the pie filled in.

If the user enters 38 I want to see 38% of the pie filled in, etc

A pie chart compares values with each other. You need to have another value which will be the remainder of the 100%. Use both blue for the pie chart.

Assuming the user entry is a field called "slice" then use the calculation:

slice & "¶" &

100 - slice

Make the chart with this field, use the delimited text option.

  • Author

Thanks Vaughan.

It's very frustrating, I just can't get it to work for some reason. There must be a simple option that I am failing to set properly.

I have a field called "slice" and I am using your exact formula:


ChartTest::slice & "¶" &

100 - ChartTest::slice

As soon as I switch the data source to "delimited text" the chart goes blank.

You also need two values for labels.

  • Author

The result is:

25

75

You also need two values for labels.

Ugh, that was it. Thanks very much. I thought that the labels were only required if I wanted "text labels".

  • Author

Is there any way to make the chart fill it's rectangle, edge to edge? Currently my pie chart is only about 30% the size of the field. I need to put the charts into a portal and the current size ratio makes it unusable. I have tried turning off all of the extra content but it does not appear to have any impact on the size of the graphic.

Try reducing the font size of all unused parts (labels, legend, title, etc.).

  • Author

Try reducing the font size of all unused parts (labels, legend, title, etc.).

Reducing the font size did help but it's still only a couple of points in diameter when I reduce the field down to the size that I need (approximately 85 x 85pt). Perhaps I can edit the clipboard data and get the chart to display edge to edge.

For such a small size you may be better off using a web viewer. Or go back in time even further and select a picture to show out of say 20 or 30 possibles.

  • Author

For such a small size you may be better off using a web viewer. Or go back in time even further and select a picture to show out of say 20 or 30 possibles.

I am using the picture option now. The solution is running on FMGO 12. I was hoping that I would get a little better performance over the network by using a pie chart.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.