error bar problem

  • Thread starter Thread starter mrh
  • Start date Start date
M

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.
 
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.
Click to expand...

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.
 
Back
Top