1 Reply Latest reply on Nov 16, 2011 10:28 AM by philmodjunk

    Line Graph

    WarnerBros
    WarnerBros Nov 15, 2011 5:31 PM

      Title

      Line Graph

      Post

      Hello Again,

       

      I need some assistance making a Line graph.

      I have three fields:

      1. Date Received

      2. Number Received

      3. Company

       

      I am trying to set up a line graph that will have "Date Received" on the X axis, and a count of the "number received" with a separate line for each "company" on the y axis.

      I have been able to set up a graph that can show the "date received" on the x axis and "number received" on the y axis, but this is not separated by Company.

      Let me know if this is not clear. Thanks for your help!

       

      -Sam

       

      • 76 Views
      • Tags:
        • 1. Re: Line Graph
          philmodjunk
          philmodjunk Nov 16, 2011 10:28 AM (in response to WarnerBros)

          You've hit a limitation to the current implementation of FileMaker Charts.

          To get a separate line for each company, you must chart a separate field for each--not what we normally want for our table structure here.

          You may be able to get this to work for you if you set up a special table just for charting where you can pull data via relationship from each company into a different field, with one record for each date in this special purpose table.