Insert lines in the verticle axis of bar chart

Hi Nithya,

Based on your description, you want to add Strip Lines in your chart. Please refer to the steps below:

1. Click the vertical axis.


2. Select “StripLine” section in the Properties dialog box. Click “…” icon.


3. In the ChartStripLine Collection Editor dialog box, set the BackgroundColor property of Appearance to red.


4. Set the IntervalOffset property of Interval to 70%, StripWidth with value 1. If we want to add dynamic Medium and Good values, we can use expression to control the IntervalOffset value.


5. Then, we can use the same method to add the other strip line in the chart.
   
   Reference: http://ift.tt/1ffX0U6

There is a screenshot for your reference:

Regards,

Alisa Tang

---

Alisa Tang

TechNet Community Support