Individual error bars

[Nodak]

I have created a graph with 6 separate estimates. I also have the amount of
error associated with each estimate (+ or -). How do you place error bars
around each estimate in the graph? I have gone to the Y error bar tab and
tried the custom application but it only applies one value to each estimate.
Is there some way to graph the error associated with each estimate rather
than one value for all estimates?

Regards

 

[J. Sperry]

In the Custom section, you are able to enter a range pointing to the actual
error you've calculated. For instance, with 6 data points, type
"=Sheet1!$D$2:$D$7" for both positive and negative error values, assuming
you've entered the error in cells D2 through D7. (For some reason, I think
the sheet name is required.)