Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
In presentatin tab there is a Reference line box, add your expression there.
Hello Sandip,
To add reference line in your chart, follow this:
Chart properties--> Presentation Tab--> Click on Add button. See below image:
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
Presentation tab -> Go to Reference lines --> Add Default or calculated vale in Expression
HI sandip
Andy replied with clear picture of how to do it. Just follow his steps I think it's enough for your query
Do as per the instructions given by andy.
in expressions tab there is trend lines option. if you select there average then line will get in the chart
thanks and regards
Rasool
Presentation tab -> Go to Reference lines --> Add -->give any value based on your refernce line -->60