Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Chart using Filemaker Pro

filemaker pro 9 excel chart

  • Please log in to reply
6 replies to this topic

#1 Papabjoe  enthusiast

Papabjoe
  • Members
  • 93 posts
  • LocationPhoenix, Arizona
  • FM Application:9 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Time Online: 5h 12m 14s

Posted 16 January 2012 - 12:35 PM

Hello all.

I have a problem that may be a step backwards for most of you. Starting in Version 7, I was an active user and developed some almost sophisticated solutions. Over time, my needs for FM dropped and as a result, so has my expertise.

My new role in my job requires some charting that would typically be done in Excel. However, I am doing most of the data entry and reporting in filemaker 9.

I need to create bar charts and I need a quick way to accomplish this.

My current idea, without upgrading to 11, is to create the summary date I need, export it as an excel file with the command to launch the application once the export is complete.

From there I would manually select the data and create a chart.

Question?

Is there a more efficient way to do this in filemaker 9 for mac? I'm not able to purchase any additional software or plugins. Ideally, I'd like to script it so that it not only exports the data but launches excel, and creates the chart. The reason being is that others in my office, may have to perform this task, and they are less than literate in FM, or excel for that matter.

Thank you for your assistance.
  • 0

#2 Agnes Riley  novice

Agnes Riley
  • Members
  • 129 posts
  • LocationNY, NJ
  • FM Application:11 Advance
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Expert
  • Certification:10, 11
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 27d 4h 51m 53s

Posted 16 January 2012 - 03:24 PM

Truthfully, the best way to go about it is to upgrade to FM11. Or use a chart plug-in, like fusion charts.

I did, however, created an AppleScript some time ago that sent the data to Excel to chart it then got the chart stored as a picture in FileMaker. Too bad these things break with every OS and software update.

So, back to my original suggestion: upgrade your FM version. That are quite a few new things in 10 and 11 over 9; you'll appreciate them.
  • 0

#3 Papabjoe  enthusiast

Papabjoe
  • Members
  • 93 posts
  • LocationPhoenix, Arizona
  • FM Application:9 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Time Online: 5h 12m 14s

Posted 16 January 2012 - 03:37 PM

Thanks, but my issue is that I'm entrenched in an excel only office. My superiors are skeptical filemaker is as neato as I keep telling them it is. Needless to say, authorization to purchase upgrades or plugins is not going to happen. If I can make this work and satisfy the requirement for charts, I can then illustrate how I had to bubble-gum and chicken-wire the solution together. While that may or may be enough to motivate the purchase of an upgrade, I still need the solution. Believe me, if I could buy it, I would.

I will look into fusion charts though. Thanx for the tip.
  • 0

#4 comment  consultant

comment
  • Members
  • 24,199 posts
  • Time Online: 329d 16h 10m 7s

Posted 16 January 2012 - 03:38 PM

I'm not able to purchase any additional software or plugins.


There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---
FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Edited by comment, 16 January 2012 - 03:39 PM.

  • 0

#5 JerrySalem  journeyman

JerrySalem
  • Members
  • 320 posts
  • FM Application:12 Advance
  • Certification:11, 12
  • Time Online: 4d 17h 41m 15s

Posted 21 January 2012 - 11:44 AM

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;
http://code.google.c...ing_charts.html
put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;
http://code.google.c...art_wizard.html

this looks like a great tool!

Jerry
  • 0
Jerry Salem
IT Solutions, Inc.
--
If not now... When?

#6 ron G  Amateur Developer

ron G
  • Members
  • 623 posts
  • LocationCoeur d'Alene, ID
  • FM Application:12 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 6d 2h 47m 34s

Posted 11 January 2014 - 06:33 PM

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---
FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Jan 11, 2014.  FusionCharts 'free' is no longer available.


  • 0

#7 ron G  Amateur Developer

ron G
  • Members
  • 623 posts
  • LocationCoeur d'Alene, ID
  • FM Application:12 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 6d 2h 47m 34s

Posted 11 January 2014 - 06:39 PM

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;
http://code.google.c...ing_charts.html
put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;
http://code.google.c...art_wizard.html

this looks like a great tool!

Jerry

Jan 11, 2014

Chart Wizzard is removed.  Code Playground is not useful in telling me how to get Google Charts to recognized FM tables.

Attached Thumbnails

  • chartwizzard.png

  • 0





FMForum Advertisers