How can I apply different error bars to each data point in a series?

Asked by nikipedia (28098

) March 16th, 2010

I need to make a graph. In this graph I need to assign different error bars to data in the same series. This figure should explain in < 1000 words.

Error bar 1 and error bar 2 need to have different values. The only way I can figure out how to do this is to make them separate series. Which makes absolutely no sense. Surely there is a way to do this? Probably a really obvious one?

I am willing to use any graphing or presentation software to do this (numbers, keynote, excel, powerpoint, openoffice, google docs, etc.)

Thanks guys.

Observing members: 0

Composing members: 0

3 Answers

You should be able to use Excel’s standard Error Bars

It won’t look like a separate bar, but I would think the standard error bars would be preferable to the example you gave…

se_ven (789

)“Great Answer” (1

) Flag as…

I don’t think this addresses my problem, which is that I can’t figure out how to specify error bars with different values for data points in the same series. Excel seems to insist on giving every data point in the series the same error bar.

nikipedia (28098

)“Great Answer” (0

) Flag as…

If you look at point 3.2 (of the above link) you can set the error bars to a range in your workbook. So you can enter the individual error bars next to the data points and have them display on that data point on the graph.

se_ven (789

)“Great Answer” (1

) Flag as…