2 Replies Latest reply on Feb 18, 2016 5:46 PM by user19752

    x axis


      Filemaker 14

      Have a chart showing 4 fields on x axis, Count, low $$, avg $$, high $$

      Want count to be a whole number "32" and would like the $$'s to be 3 decimal points "$1.125"

      In the chart layout I am using Data Type number and Format as entered. Not sure what "as entered" means.

      If I look at the data in a table view, the $$'s are formatted x.xxx and count x

      When viewed in chart $$'s show as 2 or 2.1 or 2.112

      Is there a way to have mixed number formats on x axis ?



        • 1. Re: x axis

          There are lots of little limitations like this in FileMaker's charting.  What is nice is that FileMaker charting is easy.  But specific formatting and tweaking of the charts is often not possible.  For this reason, I often use Google Charts API and a Web Viewer to display them and you have a lot more choices to work with.  It certainly gives you many many more options than FileMaker's charting, but it also is a lot more complicated.  You need to know HTML and character manipulation in FileMaker very well to make the HTML that will pull in the chart the way you want.  There probably are some other good charting APIs out there that are good too, but Google is used a lot and well documented. 

          • 2. Re: x axis

            How do you use 4 fields in x axis?

            I assume something like

            List ( Count ; low ; avg ; high )

            with Data source as "current record", then you can use "Text" for Data Type then use any calculation on it.