Chart help.....

[#1]

Hi,

I have the chart below but I want the target to be a dotted line across the axis.  Can anyone advise how to do this?

Thank you.

[alexandros17]

Go in "presentation" tab, then press the button "Add" in the box "reference lines" and write your expression

[Clever_Anjos]

Use "Reference Lines" under "Presentation Tab"

[Nicole-Smith]

Is Target an expression?  If it is, change your chart type to Combo Chart, choose Bar for the YTD Sales expression, and choose line for Target expression.  Then click the + next to the Target Expression, and in Line Style put:

='<S3>'

[chiru_thota]

[MK_QSL]

Pls check enclosed file.