9 Replies Latest reply: Nov 1, 2011 12:12 PM by Kiran Rokkam RSS

    Reference lines for charts

      Hi all. I have a year over year line chart showing data for the past 8 years (see attached: x axis shows each month; every line in the chart shows values for a different year). I'd like to be able to add in a reference line that shows the average for each month (ideally across the past 5 years, but across all if necessary). I'm not sure how to go about doing it. I've tried using the reference line feature in the presentation tab of the properties box, but I can't figure out how to include the dimension into the equation. I've also tried using an average trendline, but that just gives me the average line for each year instead of an average value for each month (see second image). Any help would be much appreciated!