Generally error bars (standard deviations) vary point-by-point in a graph
depending on the distribution of individual values for each point. Excel can
calculate these separate standard deviations, but there appears to be no way
to display them in a graph. Has anyone found a way around this?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...excel.charting
You can easily apply custom error bars to a series. I describe how he
peltiertech.com/Excel/ChartsHowTo/ErrorBars.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______
quot;delquot; gt; wrote in message
...
gt; Generally error bars (standard deviations) vary point-by-point in a graph
gt; depending on the distribution of individual values for each point. Excel
gt; can
gt; calculate these separate standard deviations, but there appears to be no
gt; way
gt; to display them in a graph. Has anyone found a way around this?
gt;
- Jun 04 Wed 2008 20:44
Calculate and display individual error bars for individual points
close
全站熱搜
留言列表
發表留言