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

      Hi,

       

      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.