Progress chart with a average hurdle bar ( Attachment)

[kuzna26]

Hey guys,

I need your assistance, I have managed to create a graphic , displaying Goal to Achieve , Task Achieved and Average


I would like to show the average hurdle bar to cover vertically all 12 Months ( Jan- Dec) , but it just cover only 10 months

any ideas please there the attachment

Thank you

Antonio

[sreekhosh]

Hi Kuzna26,

Please find attached the chart.

Follow below Steps to do it.

1)As shown in the attachment please add a new serien in the chart. (06:P7)/
2)change it into scatter chart (with only Marker).
3)Select the Scatter chart and enable secondary Horizontal Axes (Layout-Axes-Secondary Horizontal Axes-Show Defaults Axis)
4)Select this Axes and 0 as Min Value and 1 As Max value.
5)Select the Scatter chart and enable secondary Vertical Axes (Layout-Axes-Secondary Vertical Axes-Show Defaults Axis)
6)Select this Axes and 0 as Min Value and 2 As Max value.
7)Select the Scatter and add Error Bar (Layout-Error Bars-Error Bar with Percentage).
8)Delete the Horizontal Eror bar (if there is)
8)Set Error Bar Vertical Percentage as 95%
9)format the error bar as you need.

Regards

Sreekhosh