error bar problem

[mrh]

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.

 

[dvt]

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

 

[mrh]

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