3 Replies Latest reply: Jan 12, 2016 1:30 PM by Sangram Reddy RSS

    Fixed reference line in chart - is it possible?

    Trinh Le

      Hello everyone!

       

      I have a chart from sum of a specific col.A and a reference line with avg(col.A) as value. This reference line changes along with the whole chart when selections are made in the filters and tables in the sheet.

       

      Is it possible to have a reference line that always shows the average value of col.A regardless of the selections in the tables? If yes, please show me how.

       

      Thanks in advance!