5 Replies Latest reply on Mar 30, 2015 8:18 AM by Harry

    Column Chart Scale resizes width of columns.



      Column Chart Scale resizes width of columns.


      FileMaker Pro


      Operating system version

      Win7 64bit

      Description of the issue

      A column Chart is built and the scales are set from 0 - 50,000. 'Months' field is plotted across the bottom and shows as text 'January - December'.

      A Y data set is added, 'Forecasted_Sales' which is in the Months table and is a text field entered by hand.

      This chart is Transparent and has grey text on the axis.

      This is then Copy/Pasted so a second identical version is aligned on top.

      The second chart on top is then edited and a different field required for the Y is changed in the field. Still Months, but from a Calc field referencing another table occurance.

      (This Calc field is a Sum total from a table occurance that holds Sales_Orders.)

      Steps to reproduce the problem

      Tried using hand-entered (non Calc'd) fields/data.

      Tried going through Issue and then swapping back to original data (this works and returns the chart to it's 'working' state).

      Expected result

      I expect both charts to align perfectly with each other, the columns on the uppermost chart overlay the forecast columns and 'grow' into the 'container' of the underneath chart.

      This gives the viewer an instant view of whether the Forecasted Sales have been acheived.

      Ideally, Forecasted Sales, Entered Sales and Shipped Sales should be shown with Red, Orange and Green columns representing those three stats.

      Actual result

      The data shows, but the graph has resized it's X axis scale - the columns are thinner and the distance between them is also thinner. This result is a chart that does not align over the chart underneath.

      Both charts have boundary boxes that are the same size and remain unchanged through the copy/paste process and through the change of Y data.

      Exact text of any error message(s) that appear

      No error message, chart resolves.

      Configuration information

      Data from MySQL table occurnance provides data for Calc'd SUM function that is the 'Total_Sales' field plotted on the graph.

      DB is held on FMS13.


      Gradually stretching the boundary box makes one column fit over the other, but shows that alignment quickly and exponentially drifts over the length of the chart.


        • 1. Re: Column Chart Scale resizes width of columns.

          Here is a jpg of the chart as it is copy/pasted.

          It is all OK and rendering the correct data accurately.


          The only difference between this and the first image is the Y axis data field has been changed.



          • 2. Re: Column Chart Scale resizes width of columns.


            Thank you for your post.

            In both of your printouts, it appears the Y-axis remains the same (90,000 upper limit).  True?  What has changed in the Y-Axis?

            Does this issue occur with a new layout?  Does this issue occur with a new file?  That is, if you create a new file with the same values, does the issue still occur?

            FileMaker, Inc.

            • 3. Re: Column Chart Scale resizes width of columns.


              Thanks for the reply.


              The scale of the Y is set to be the same. So, i went into the Inspector and set the first chart to be 0-90,000 with 5K increments. Then Copy/Pasted into another chart that held that same scale.


              The Y has only had its data field changed to a different field, from the same table, but the new field is a Calc field which sums totals of a different table.


              I have not tried this with a new layout! I will do that this afternoon and report.

              I have not tried thsi with a new file!

              How should i try to duplicate this issue in a new file? Should i setup tables and data from scratch? Then move closer to using original layouts, tables and relationships?




              • 4. Re: Column Chart Scale resizes width of columns.


                I don't have enough information to determine what is the cause.  Therefore, eliminate some possible causes will help narrow the paths to take.  Creating a new layout will help me determine if it is a layout issue.  Be sure to create a new layout and not duplicate the existing layout, as the duplication would possibly include any bad objects.  If the layout is not the issue, then I would create a new test file with the minimal fields necessary (Do not try to create the entire file again!).  Add some test data to try and replicate the issue.  If it works, then delete those records and import the records from the main file and try again.

                All of this will help me determine if it is a layout issue, a file issue, or a FileMaker Pro issue, and this will then let me know the next steps to take.

                Please keep me updated with any progress.

                FileMaker, Inc.

                • 5. Re: Column Chart Scale resizes width of columns.



                  Fantastic, thank you. I will do this. It will take a few days but I'll try it and report back.


                  If this is an issue with FMP - I'd like to put in a request for a scale setting on the X, like there is on the Y. And also, to be able to alter the colours of differing series' within a chart - rather than having to use the predetermined colour palettes. They look great, but for displaying data in summary form (read, chart) they *can* be, sometimes, useless. Complimentary shades of purple or Sea Foam or whatever make my A4 printout look sparkly and shiny and like i know what i'm doing and should be listened to. But it's not representative sometimes.

                  Internally we use traffic light type status. Red/Amber/Green, displays status in lots of different ways and I am trying to replicate this. Otherwise, i could use area line charts.

                  Thank you again, TSGal!