adding vertical average line to bar chart.

[lezawang]

Hi
I am trying to add vertical average line to a bar chart. I tried similar to what is in the link below, which is to add horizontal average line but it is a bit different for vertical line. When I changed the chart to scatter line, the average chart changed to a point/dot and I could not do anything else. Any help please. Thank you.

https://www.extendoffice.com/documents/excel/1265-excel-add-average-line-to-chart.html

 

[Worf]

Hi

https://www.extendoffice.com/documents/excel/2344-excel-add-vertical-line-to-bar-chart.html