How to do histograms/bar charts / any charts

I wonder how do you do any type of charts in Filemaker. Being a student I cannot afford to buy xmChart, I can't find any information about helper [to use Excel to do it]. Can someone give me some advice? Thanks!

You can always create circa-1960s bar graphs... Bar01 (calculation, text result) = Left ("**********",n) .... where n is the number of asterisks to display (1 to 10). What, you say you need something more sophisticated? Well, I suppose you could use a font like Zapf Dingbats or Wingdings as a step up from asterisks. If you need higher resolution than 10 "bars" you can use a hundred or so "vertical line" ("|") characters. Some people have also employed various approaches involving container fields holding images. For example, you could create a table holding a hundred identically-sized GIF images, each filled with a different percentage of color to indicate the value. You could also send a message to another program telling it to graph data supplied by FileMaker. Good luck with that project; it will take forever to figure out and debug. Of course, the methods I described here only work for bar charts. For pie charts and line graphs you're out of luck. It's really sad that in two decades of development, FileMaker has never seen fit to supply end users with even a rudimentary graphing module. Or even, as you mention, documentation/templates for accomplishing it with Excel. [Kudos to xmChart (http://www.x2max.com) for doing what they do.] "Ilario Corna" <gibberish@nobody.ca> wrote in message news:EwHDd.68769$P%3.2371786@news20.bellglobal.com... >I wonder how do you do any type of charts in Filemaker. > Being a student I cannot afford to buy xmChart, I can't find any > information about helper [to use Excel to do it]. > > Can someone give me some advice? > > Thanks!

You may also look into Brian Dunning' Chartmaker : http://www.briandunning.com/chartmaker/ which techniques cost $39.99 instead of $99 for XMchart ... Remi-No�l "Ilario Corna" <gibberish@nobody.ca> a �crit dans le message de news: EwHDd.68769$P%3.2371786@news20.bellglobal.com... >I wonder how do you do any type of charts in Filemaker. > Being a student I cannot afford to buy xmChart, I can't find any > information about helper [to use Excel to do it]. > > Can someone give me some advice? > > Thanks!

Ah, Thanks for pointing out that site. Looks like I spoke too soon about the container technique not being appropriate for pie charts. "RN Menegaux" <rnmenegaux@free.fr> wrote in message news:41dfac29$0$31539$626a14ce@news.free.fr... > You may also look into Brian Dunning' Chartmaker : > http://www.briandunning.com/chartmaker/ > which techniques cost $39.99 instead of $99 for XMchart ... > Remi-No�l > > "Ilario Corna" <gibberish@nobody.ca> a �crit dans le message de news: > EwHDd.68769$P%3.2371786@news20.bellglobal.com... >>I wonder how do you do any type of charts in Filemaker. >> Being a student I cannot afford to buy xmChart, I can't find any >> information about helper [to use Excel to do it]. >> >> Can someone give me some advice? >> >> Thanks! > >

Or you can create a charting template in Excel. Then just set up a script in FileMaker that exports the proper data and opens the Excel Macro to produce the chart. Bill Marriott wrote: > Ah, > > Thanks for pointing out that site. Looks like I spoke too soon about the > container technique not being appropriate for pie charts. > > "RN Menegaux" <rnmenegaux@free.fr> wrote in message > news:41dfac29$0$31539$626a14ce@news.free.fr... > >>You may also look into Brian Dunning' Chartmaker : >>http://www.briandunning.com/chartmaker/ >>which techniques cost $39.99 instead of $99 for XMchart ... >>Remi-No�l >> >>"Ilario Corna" <gibberish@nobody.ca> a �crit dans le message de news: >>EwHDd.68769$P%3.2371786@news20.bellglobal.com... >> >>>I wonder how do you do any type of charts in Filemaker. >>>Being a student I cannot afford to buy xmChart, I can't find any >>>information about helper [to use Excel to do it]. >>> >>>Can someone give me some advice? >>> >>>Thanks! >> >> > > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg (818) 883-2846 FM Pro Solutions Los Angeles, California FileMaker 7 Certified Developer Associate Member, FileMaker Solutions Alliance

May I ask you how do you to it? Is there a free tutorial that you can point me to? Thanks Howard Schlossberg wrote: > Or you can create a charting template in Excel. Then just set up a > script in FileMaker that exports the proper data and opens the Excel > Macro to produce the chart. > > Bill Marriott wrote: > >> Ah, >> >> Thanks for pointing out that site. Looks like I spoke too soon about >> the container technique not being appropriate for pie charts. >> >> "RN Menegaux" <rnmenegaux@free.fr> wrote in message >> news:41dfac29$0$31539$626a14ce@news.free.fr... >> >>> You may also look into Brian Dunning' Chartmaker : >>> http://www.briandunning.com/chartmaker/ >>> which techniques cost $39.99 instead of $99 for XMchart ... >>> Remi-No�l >>> >>> "Ilario Corna" <gibberish@nobody.ca> a �crit dans le message de news: >>> EwHDd.68769$P%3.2371786@news20.bellglobal.com... >>> >>>> I wonder how do you do any type of charts in Filemaker. >>>> Being a student I cannot afford to buy xmChart, I can't find any >>>> information about helper [to use Excel to do it]. >>>> >>>> Can someone give me some advice? >>>> >>>> Thanks! >>> >>> >>> >> >> >

See the section titled "Run any Excel macro from within FileMaker" at <http://www.connectingdata.com/downloads.htm>. At that point, you will need knowledge of Excel macros and charting in order to build such a powerful solution. Ilario Corna wrote: > May I ask you how do you to it? > Is there a free tutorial that you can point me to? > > Thanks > > > Howard Schlossberg wrote: > >> Or you can create a charting template in Excel. Then just set up a >> script in FileMaker that exports the proper data and opens the Excel >> Macro to produce the chart. >> >> Bill Marriott wrote: >> >>> Ah, >>> >>> Thanks for pointing out that site. Looks like I spoke too soon about >>> the container technique not being appropriate for pie charts. >>> >>> "RN Menegaux" <rnmenegaux@free.fr> wrote in message >>> news:41dfac29$0$31539$626a14ce@news.free.fr... >>> >>>> You may also look into Brian Dunning' Chartmaker : >>>> http://www.briandunning.com/chartmaker/ >>>> which techniques cost $39.99 instead of $99 for XMchart ... >>>> Remi-No�l >>>> >>>> "Ilario Corna" <gibberish@nobody.ca> a �crit dans le message de >>>> news: EwHDd.68769$P%3.2371786@news20.bellglobal.com... >>>> >>>>> I wonder how do you do any type of charts in Filemaker. >>>>> Being a student I cannot afford to buy xmChart, I can't find any >>>>> information about helper [to use Excel to do it]. >>>>> >>>>> Can someone give me some advice? >>>>> >>>>> Thanks! >>>> >>>> >>>> >>>> >>> >>> >> -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg (818) 883-2846 FM Pro Solutions Los Angeles, California FileMaker 7 Certified Developer Associate Member, FileMaker Solutions Alliance

In article <Tqydnb89L9KWcULcRVn-tA@comcast.com>, "Bill Marriott" <wjm@wjm.org> wrote: > "RN Menegaux" <rnmenegaux@free.fr> wrote in message > news:41dfac29$0$31539$626a14ce@news.free.fr... > > > > You may also look into Brian Dunning' Chartmaker : > > http://www.briandunning.com/chartmaker/ > > which techniques cost $39.99 instead of $99 for XMchart ... > > Ah, > Thanks for pointing out that site. Looks like I spoke too soon about the > container technique not being appropriate for pie charts. With pixel-sized container fields plus A LOT of patience and time, you can do almost anything. :o) Helpful Harry Hopefully helping harassed humans happily handle handiwork hardships ;o)

Indeed, you can... The Pie Chart file is almost 4 MB; I'm betting he's got 360 images for each color of slice at various percentages of fill as transparent GIFs. He overlays the slices to create the complete pie chart. As for the text labels, be probably positions them using text fields, monospace font. Unfortunately, his line graph, scatter plot, and function graph appeared blank on my system. I suspect he used a font for that effect; one with slightly different metrics on my system. "Helpful Harry" <helpful_harry@nom.de.plume.com> wrote in message news:090120051226551164%helpful_harry@nom.de.plume.com... > In article <Tqydnb89L9KWcULcRVn-tA@comcast.com>, "Bill Marriott" > <wjm@wjm.org> wrote: >> "RN Menegaux" <rnmenegaux@free.fr> wrote in message >> news:41dfac29$0$31539$626a14ce@news.free.fr... >> > >> > You may also look into Brian Dunning' Chartmaker : >> > http://www.briandunning.com/chartmaker/ >> > which techniques cost $39.99 instead of $99 for XMchart ... >> >> Ah, >> Thanks for pointing out that site. Looks like I spoke too soon about the >> container technique not being appropriate for pie charts. > > With pixel-sized container fields plus A LOT of patience and time, you > can do almost anything. :o) > > > Helpful Harry > Hopefully helping harassed humans happily handle handiwork hardships ;o)

Hi I have a barchart in filemaker 3 (it can be converted to 7 I believe) I found it on the net and modified it for giving a visual chart of blood sugar readings for diabetics(I am one...that's why I did it!) anyway if you want me to send it to you give me your email address and I'll send it ...it's small (less than 200k) take the spamfilter off my email address to email me... just remove the "pants" from palomineopants Tom -----------snip---------- Ilario Corna wrote: > I wonder how do you do any type of charts in Filemaker. > Being a student I cannot afford to buy xmChart, I can't find any > information about helper [to use Excel to do it]. > > Can someone give me some advice? > > Thanks!

Similiar Articles:

Bar charts in PDF - comp.text.tex
Can I use pdftricks to produce a bar-chart in ... the other solutions only seemed to do histograms ... Frequency Plot to one third octave bar chart - comp.soft-sys ... Bar charts ...

Percentage display on Y-axis of Histogram - comp.soft-sys.matlab ...
Bar chart double y axis question - comp.soft-sys.matlab ... sides as the x- and y-axis for ... How to do histograms/bar ... ... time-based row ... 2007 supports many types of charts ...

Histogram calculation - comp.graphics.api.opengl
Bar chart double y axis question - comp.soft-sys.matlab Percentage display on Y-axis of Histogram - comp.soft-sys.matlab ... Bar chart double y axis question - comp.soft ...

two-level clustered axis bar plot - comp.soft-sys.matlab ...
Hello, I am trying to do a bar plot where ... sys.matlab two-level clustered axis bar plot - comp.soft-sys.matlab ... Histogram ... Bar chart double y axis question - comp.soft ...

Clustered Floating Bar Chart - log scale - comp.soft-sys.matlab ...
... floating bar chart that has ... Bins for Histogram - comp.soft-sys.matlab about ... sys.matlab Clustered Floating Bar Chart - log ... other symbol in a chart ... Floating charts ...

Color Bar graph in RGB colors - comp.soft-sys.matlab
bar chart with different colors - comp.soft-sys ... histogram error bar color - comp.graphics.apps.gnuplot Color Bar ... interpolation? - comp.graphics.api.opengl Bar charts in ...

plot scroll bars, x-axis spacing - comp.soft-sys.matlab
Bar chart double y axis question - comp.soft-sys.matlab plot scroll bars, x-axis ... soft-sys.matlab Bar chart double y axis question - comp.soft-sys.matlab Bar charts in ...

gnuplot and categorical data - comp.graphics.apps.gnuplot ...
Hello I don't find any sure answer: is gnuplot supporting or not categorical data chart ? ... graph on maps ... comp.soft-sys.matlab histogram error bar ...

normalized histogram - comp.soft-sys.matlab
histogram error bar color - comp.graphics.apps.gnuplot normalized histogram - comp.soft-sys.matlab histogram error bar color - comp.graphics.apps.gnuplot normalized ...

Frequency Plot to one third octave bar chart - comp.soft-sys ...
... vs Frequency giving but how do I get this in one third octave form, as in a bar chart ... histogram : values on top of the bars ... Bar charts in PDF - comp.text.tex ...

Bar graphs, pie charts and histograms
Bar graphs, pie charts and histograms Ethan D. Bolker Maura B. Mast October 23, 2007 Plan Bar graphs and pie charts Histograms - a special type of bar chart

Bar Charts and Histograms - Statistics, Probability, and Survey ...
How to read and use bar charts to display qualitative data; histograms, to display quantitative data. Includes a free, video lesson on bar charts and histograms.

7/26/2012 11:39:51 AM