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.

Graphs/Pie Charts

Featured Replies

Is there any way to do these in FMP 6? I know 7 has some built in features for graphs. Is there any way to do 'em in 6...maybe a plugin?

Check out briandunning.com.... he has created some charts using native filemaker tools. Or http://wmotion.com/all_charts.html for a plugin solution.

Dana

I kind of like the XMCharts plug-in. Many, many graph types and a lot of versatility. www.x2max.com.

-bd

Ya, I've been able to do some pretty cool stuff with the xmchart plug-in.

I've never called to ask what it was actually developed for, hard to believe the language was created for a FM plug-in. I like way it operates, you pass it some instructions in a text field and it returns the plot graphic. The instructions can be complex, but the process/integration with FM is simpler. Also makes it easy to hand type instructions to debug.

-bd

Being as cheap as I am, I avoid the plugins and just script a data dump into excel. From there just about any graph and be made.

  • Author

ya, i think that's the direction i'm heading because i too am "thrifty"

  • Author

any quick ways to do a data dump into excel for a simple pie chart or bar graph? when it exports it only takes the info from the fields themselves and does not include the field names (and it is quite time consuming to type each category up individually when you have 25 categories). any help?

  • 1 month later...

what are the built in graph features in fm7 mentioned in the first post

"What are the built in graph features in fm7 mentioned in the first post?"

None.

That's what I thought

As there is no built-in graphing feature in FMP, I'd highly recommend downloading the xmChart plugin. The free demo version is fully functional, it just stops working an hour or so into each session. Although this is no good for a finished product, it is fine for design and testing purposes. Also, it doesn't actually cost very much. Once you see how well it works, it becomes invaluable and well worth the money.

-Stanley

You could also try creating an HTML/javascript file from your data. There are a lot of good examples out there. See attached. Place bar.gif in your webserver/documents folder. Open graph.htm in a browser. There are various ways you could generate an HTML file like graph.htm from Filemaker.

Archive.zip

xmChart is good but when you want a dev license it get's a bit expensive. Will try it though, didn't know that the demo was so good. Then I can work with it and see if I can get the results I want.

Java is interesting but I surely want the graphs to be presented in the filemaker file amd finally, qliktech looks interesting but the price tag scares me off.

It seems odd to me that filemaker hasn't any graph support. I thought they would add that to version 7 but no frown.gif

Still creates great database solutions though smile.gif

  • 3 weeks later...

any quick ways to do a data dump into excel for a simple pie chart or bar graph? when it exports it only takes the info from the fields themselves and does not include the field names (and it is quite time consuming to type each category up individually when you have 25 categories). any help?

I would've thought that the easiest way is to have the first record with the actual feild names entered into it, so when you export, Excel can use this record as the field headers.... not sure about number fields though ooo.gif

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.