General Question

nikipedia's avatar

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

Asked by nikipedia (27475points) 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

se_ven's avatar

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…

nikipedia's avatar

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.

se_ven's avatar

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.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther