How do I plot a column average ?
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? |
How do I plot a column average ?
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 "Tom@Purdue" wrote: 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? |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com