How do I plot a column average ?

[Tom@Purdue]

I need to make a column chart that plots the average of a column of data,
with error bars matched to the data (i.e. data series 284, 295, 214, 212
should plot bar with height 251 and error bars from 213-289). How do I do
this in Excel 2007?

 

[Tushar Mehta]

In an adjacent row/column compute the average of the data series. You should
as many data points as in your series.

Plot both series in a column chart. Select the average series, then
right-click and select 'Change chart type' Change the chart type to a Line
Chart. Since you had selected a series the change affects only that series.

Select the original data series (the column chart) and add error bars of
size 1 standard deviation. In Excel 2007 select the chart, then the
contextual tab Chart Tools | Layout. In there from the Analysis group select
the Error Bars drop down.

FWIW, the error bar range you specified corresponds to the standard
deviation of the population, not the sample. Maybe, that's what you want but
by default Excel will give you the std. dev. of a sample.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu