Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
Plot data from column to matrix | Excel Discussion (Misc queries) | |||
Plot data from column to matrix | Excel Discussion (Misc queries) | |||
How can I get the average of curves on a plot? | Charts and Charting in Excel | |||
calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) |