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