Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Individual error bars
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Individual error bars
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.) "Nodak" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I specify min/max error bars for individual data points? | Charts and Charting in Excel | |||
How do I do individual error bars for bar graphs? | Charts and Charting in Excel | |||
Individual Error Bars | Excel Discussion (Misc queries) | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel |