View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

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