Progress chart with a average hurdle bar

[kuzna26]

Hey Guys ,

Please I have a excel sheet with the following assignment
there are 3 teams with different assignments


Assigned Tasks Complete Tasks Average Achieved per Team % Target %

Team A 150 149 126 99% 100%

Team B 130 120 126 92% 100%

Team C 120 110 126 92% 100%

T/Total 400 379 126 95% 100%


I have set up a progress chart that includes Assigned Tasks and Complete Tasks , but I would like to include a average hurdle bar which equal 126

Any help hope in make sense

Thanks

[Andy Pope]

Normally you would use another series and either draw the line or use error bars.
But as you already have a bar on both primary and secondary axes this is not an option.

What you can do is add another bar to the secondary axis and use a vertical bar as the character for a data label. If you center the data label and use a bar with twice the value the line will be correctly positioned.