AnsweredAssumed Answered

Create column chart with multiple years/jan-december on one chart

Question asked by JohnPiscopo on Jun 30, 2013
Latest reply on Jul 1, 2013 by philmodjunk

Title

Create column chart with multiple years/jan-december on one chart

Post

     I am new to Filemaker. I am trying to create a column chart from a table with 6 years on the chart with the x-axis being Jan, Feb, Mar, etc.. I have created the chart but can only get one year to list on it. The chart below is for one year Jan-Dec. I need to have this chart show and average for Jan, Feb, etc  for each year with Jan showing 5 columns one for each year. The examples I have found show a single record for the total for the month of Jan, etc.. My records are based on weekly data. The totals are in a single field for all months reguardless of the year. I take the 4 or 5 weeks and select an average for that month. Thank you.

      

      

      

Outcomes