Scatter chart with error bars (XL 2K)

Is there a way to select four columns and have Excel plot a scatter chart with the X's from column 1, the Y's from column 2, and the Y-error bars from columns 3 & 4. I am starting to write a macro to do it, but if Excel can do it, that would be better. Thanks! --Sam

<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic><small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Re: Scatter chart with error bars (XL 2K)

Sam,

As far as I know, the way to do it is making a XY-scatter chart, then doubleclick the data series and go to Y-errorbars in the data series format window. There you have a custom + and - refedit box where you place your cursor and select the errors from your column 3 (probably for the +) and from your column 4 (probably the -).