Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel Finished File: https://people.highline.edu/mgirvin/Y...
Full Page With All File Links: http://people.highline.edu/mgirvin/ex...

See how to add the Mean Value as a Scatter diagram Data Series to a Box Plot or Box & Whisker that is set up as a Bar Chart.
Add Data Series To Chart When Data Series Are From A Scatter Diagram and a Bar Chart.
Excel Chart Scatter Diagram Bar Chart
Also see this video:
Excel Magic Trick #124: Box Plot or Box & Whisker