Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual point standard error bars on chart
I am trying to add standard error bars to an Excel chart -
and in the Excel functions, it adds the same size error bar to all points. How can I program/configure it to show assigned error values specifically to each individual point? My errors are a standard deviation on the mean of each point. Each point (the mean value) is calculated from a different number of values. Thanks for any help you can give on this, Paul Nelson. ps I have posted this to the Worksheet Functions group as well. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual point standard error bars on chart
Hi Paul,
There is a Custom Values available for both positive and negative. On the error bar tab of the format dialog of a data series. Enter in the range that contains the individual values you require. Paul N wrote: I am trying to add standard error bars to an Excel chart - and in the Excel functions, it adds the same size error bar to all points. How can I program/configure it to show assigned error values specifically to each individual point? My errors are a standard deviation on the mean of each point. Each point (the mean value) is calculated from a different number of values. Thanks for any help you can give on this, Paul Nelson. ps I have posted this to the Worksheet Functions group as well. -- Cheers Andy http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
Individual error bars | Excel Discussion (Misc queries) | |||
Standard 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 |