Column Chart Regarding.

[aligahk06]

Dear All,

I have a column chart with different percentage. I want to give a thresold horizontal line in a chart 20 % and 10 %.
Any help or suggestion.

---

---

Regards,

Aligahk06

 

[jarjarbingie]

Dear All,

I have a column chart with different percentage. I want to give a thresold horizontal line in a chart 20 % and 10 %.
Any help or suggestion.

---

---

Regards,

Aligahk06

Add 2 more data series, one for 20% and 10% where the values are 20% and 10% across. Change the chart type to Combo Chart, bar for the %, line for 20% and 10%.

 

[aligahk06]

Dear jarjarbingie,

I tried but didn't get result. my problem is like this. Y- Axis (Vertical) 0%, 10%,20%,30%,40%,50% X- Aixs (Horizontal) - Jan , Feb , March, ........Dec.

I want to give my bar chart a bold line to 10% (Target) and 20% (Threshold) Parallel to X- Axis. and then bar chart within the thresold.

Any Help,

Rgds,
Aligahk06