5 Replies Latest reply: Sep 17, 2014 4:21 AM by Alex Hamilton McLeod RSS

    ONE linear trendline, for bar chart

      Is it possible to have one linear trendline, for a bar chart with 3 dimensions?

       

      If I tick the 'Linear' box i get a trendline for each value, which I do not want. I only want one one trendline for the total

      multiple trendlines.png

       

       

      The only way I can see to do this is to remove the 3rd dimension, but i do not want to do this!

      linear trendline.png

       

      How can i retain the stacked bar chart and also only have one trendline for the total?

       

      My expression is very simple:

      =SUM(Revenue/1000)