Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Suppose I have some values and I compute the mean, which I plot in a bar
graph as one bar. Now, in the Format Data Series menu, under the Y error bar tab, I see the option of "Standard deviation" and "Standard error". I can't figure out how to use those; what I do now is put the stdev() of the values into a separate cell and use that cell in the "Custom" field of the Y error bar tab. But this must be the clumsy way of doing it, if it has "Standard deviation" and "Standard error" as built-in options. Presumably for it to use "Standard deviation" and "Standard error" it has to know (I have to select) the whole series of numbers, but then how do I tell it to plot the mean as the value of the bar itself? Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make the "series" option available under the Fill Menu? | Excel Discussion (Misc queries) | |||
Using Option Buttons from the "Forms" Menu | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
No "Excel Services" option in Publish menu | Excel Discussion (Misc queries) | |||
"assign macro" not an option from short menu | Excel Discussion (Misc queries) |