error bar problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrh - 03 Nov 2003 19:28 GMT

I have a scatter plot chart with 3 different data sets. I need to add
error bars to each individual data point in each data set. When I add
error bars, it uses the same value for each point in the same data set.
How do I get around this problem? Your help is greatly appreciated.

------------------------------------------------

Reply to this Message

dvt - 03 Nov 2003 19:50 GMT

> I have a scatter plot chart with 3 different data sets. I need to add
> error bars to each individual data point in each data set. When I add
> error bars, it uses the same value for each point in the same data set.
> How do I get around this problem? Your help is greatly appreciated.

Select the error bars by clicking on them. On the menu, click Format |
Selected error bars | X (or Y) Error bars tab. You can put cell
references in the Custom + and - boxes. So for example, if your data was
in A1:B10, your positive errors might be in C1:C10 and the negative errors
in D1:D10.

Signature

Dave
dvt at psu dot edu

Reply to this Message

mrh - 04 Nov 2003 13:16 GMT

Thank you very much. I'm working on my thesis and this is the last
thing I need to do.

------------------------------------------------

Reply to this Message