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?
Go in "presentation" tab, then press the button "Add" in the box "reference lines" and write your expression
Use "Reference Lines" under "Presentation Tab"
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:
Pls check enclosed file.
Retrieving data ...