2 Replies Latest reply on Jun 14, 2016 2:55 AM by Sebastian Hopfensperger

    Remove one Year from an average reference line on bar chart, whilst still showing the Year bar.

    Sebastian Hopfensperger



      I have a simple bar chart with years across the bottom (X) and Sales up the side (Y). I have added an Average Reference line that is showing me the average across all years, which in this case is 1996 - 2017 (2016 and 2017 are estimates).


      I would like to be able to exclude 2017 from the average line, but keep the 2017 sales bar shown as the estimate. i.e. the average line is 1996 - 2016, and the bars show 1996 - 2017.


      Is this possible?


      Thanks in advance.