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