How to display the arithmetic mean of all the values in a bar chart?

[sarahsez]

SteerCoDec31Metrics.jpg
The attached screenshot is from a PowerPoint add-in called think-cell. I'm trying to create a similar
chart in Excel 2010. Currently, we have to copy values from Excel by hand and paste them into PPT.
We want to avoid the need for human intervention. Thanks.

[teylyn]

Hello,

you can create the chart in Excel and embed or link it to the PPT file. See a chart attached. It uses two data series, one for the columns, the other one is a line chart. The chart is set to connect empty data points with a line.

cheers,