pivot chart, mean and standard error

  • Thread starter Thread starter Misange
  • Start date Start date
M

Misange

hello,
I'm using a pivot table to calculate the mean and the stdevp of values
collected in different condition.
My problem is to draw the corresponding chart for the means of the
values, and using the stdevp values for the error bars.
Using a stacked histogram, I have something which resembles to what I
would like but I would prefer to have a classical error bar. Is there a
way to manage ? I want to keep something automatic and not static, with
a copy/paste values to draw manually my charts.
Thanks for your help
 
You will have to make a regular chart from the data, because pivot
charts aren't flexible enough to manage this. Select a blank cell that
is surrounded by blank cells (so Excel won't try to guess which data you
meant to select) and start the chart wizard. In step 1, select the chart
type you want for the mean values: bar, column, line, whatever. In step
2, select the ranges for the values and category labels using the Series
tab. In step 3, click on the error bars tab, click in the Custom + box
and select the range with the standard deviation values. Click in the
Custom - box and select the same range. Hi OK a couple more times and
you've got your chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Hi Jon,
The advantage of your solution is that it always work. And you can
arrange your data in the pivot table as you want.
GeeDee in the french newsgroup had another suggestion wich works
although it's not perfect : the data in the pivot table have to be
organized so that the columns contain side by side only the mean and the
stdevp values. This is OK but means that you loose the flexibility to
move your row or column labels...
The chart will then show side by side 2 bars, one for the mean, one for
the stdevp. Create a custom graph : Hide this second bar with an
appropriate format. Then double clic on the mean serie, and in the error
bars tab, select the proper range, which is in the pivot table.
This custom format has to be applied each time the table is updated (or
with a macro).
I am often stuck with the problem to synchronize mean and standard deviation
Thank you for your help Jon.

Misange migrateuse http://www.excelabo.net
mail : http://cerbermail.com/?k5Q8Dh2mta

le 15/05/2004 03:17:
 
Back
Top