Straight Line in Line Chart

[#1]

Hello, I have a line chart where i have amounts in yellow and blue that i want stacked. However, I need to make the third expression, which is the target, a straight line instead of stacking on top. How can I achieve this?

Thanks in advance!

-Jason

[Gysbert_Wassenaar · Accepted solution]

If the target line is the same value for every dimension value on the x-axis then you can use a reference line which you can add on the Presentation tab. Other wise you either have to use two charts and put them on top of each other. Or you'll have to do a lot of calculating to create expressions that result in correctly stacked areas. The combo chart doesn't support areas + line(s).

[#3]

Apologies for the earlier comment that I had to delete. I'm struggling to use a reference line to recreate the target. My dimension is Quarter and has values of Q1 - Q4. I tried using the following expression to create the line but it is not working: =right([Quarter],1) * 110

[Gysbert_Wassenaar]

A reference line can have only a constant value. If you use an expression for the reference line then it can return only one value. It will be calculated at the chart level, not at the level of dimension values.

[#5]

Got it, thank you!

[#6]

Thanks Gysbert! I ended up stacking a chart on top.

-Jason