Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set different error bars per data point in a series
Prior versions of Excel allowed different error bars per data point. I am
now using Excel 2003 and apparently error bars can only be set for the entire series. Since my data points in a series are really averages from other series I want to include their error bars. |
#2
|
|||
|
|||
Hi,
XL 2003 still have the option to plot custom error bar values. Double click the series and check the Error bars tab, there should be both a custom positive and negative refedit control to allow you to select a range to use. Check Jon's page for example and screen shots. http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html Cheers Andy Trebor1 wrote: Prior versions of Excel allowed different error bars per data point. I am now using Excel 2003 and apparently error bars can only be set for the entire series. Since my data points in a series are really averages from other series I want to include their error bars. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
I don't know why people think that charting features have been removed
from Excel 2003. Either the features are still there, where they always have been since Excel 97 (during which time very few changes have been made), or the features never existed (like data labels in up-down bars in a line chart, which someone requested last week). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, XL 2003 still have the option to plot custom error bar values. Double click the series and check the Error bars tab, there should be both a custom positive and negative refedit control to allow you to select a range to use. Check Jon's page for example and screen shots. http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html Cheers Andy Trebor1 wrote: Prior versions of Excel allowed different error bars per data point. I am now using Excel 2003 and apparently error bars can only be set for the entire series. Since my data points in a series are really averages from other series I want to include their error bars. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |