ONE linear trendline, for bar chart

[#1]

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

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

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)

[rubenmarin · Accepted solution]

You can try to create an expression, unchecking 'Bar' and checking 'Values on data', in this expression is where you have to check the linear trendline.

The expression should be something like:

Sum(TOTAL <Week> Revenue/1000)

[#3]

I get the error message 'Drawing of chart failed internally' when I tried to do this

[#4]

Is it possible to use a Reference Line? I can't figure out what the formula would be though

[rubenmarin]

I have done this with 2 dimensions, I added one more dimension to my graph and still draws it.

Can you upload a sample?

[#6]

i used the wrong 'week' field

it worked! thanks so much