How to create the red boundary line in bar chart

[ananyaghosh]

How to create the red boundary line in bar chart like the attached image? Actually my client want me to show it as target line. But I cannot understand , how to do it. Please help me about it.

[alexandros17]

In presentatin tab there is a Reference line box, add your expression there.

[jsingh71]

Hello Sandip,

To add reference line in your chart, follow this:

Chart properties--> Presentation Tab--> Click on Add button. See below image:

[awhitfield · Accepted solution]

HI Sandip,

that looks like a reference line. You can create one on the Presentation Tab of you chart.

Click ADD, select the required values, Color, expression etc

and you get:

HTH - Andy

[pavendhan]

Presentation tab -> Go to Reference lines --> Add Default or calculated vale in Expression

[#6]

HI sandip

Andy replied with clear picture of how to do it. Just follow his steps I think it's enough for your query

[#7]

Do as per the instructions given by andy.

[#8]

in expressions tab there is trend lines option. if you select there  average then line will get in the chart

thanks and regards

Rasool

[pratap6699]

Presentation tab -> Go to Reference lines --> Add -->give any value based on your refernce line -->60