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: