Scatter chart with error bars (XL 2K)

Topic

New Reply

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

Reply | Quote

Replies

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 -).

Reply | Quote

Not any more. I just select four columns and run the ScatterWithErrors macro!

Reply | Quote