Custom Error Bars

**Andy Pope** · 10-03-2009, 12:43 PM

Not sure how I can explain it any easier. The article has details and pictures.

You need to have the various error bar values in a range, one value for each data point.
You then use the Select Custom to select the range for both pos/neg errors.

If you are still stuck post a workbook

**kd001** · 10-06-2009, 03:55 AM

Ok. Here's my attempt. Vertical error bars are fine sine they have a fixed value. I have entered the horizontal error bar values in column C. In the horizontal error bar options I selected custom and then selected all the error values in column C as the value for both positive and negative error (after deleting the default entry). The error bars however still don't much the values in column C.

Thanks again.

**Andy Pope** · 10-06-2009, 05:29 AM

Your chart is correct.

Why do you think the error bars are wrong.
Take a look at the point I have altered the values on. It appears to align correctly.

**kd001** · 10-06-2009, 07:51 AM

Thanks. I guess I just posted it in a hurry without looking at it too carefully. Also I probably expected it to be wrong because its was my first attempt at doing this.

Anyway thank you. I now know how it works.