ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error bars (https://www.excelbanter.com/excel-discussion-misc-queries/252525-error-bars.html)

ALEX

Error bars
 
I wish to add different error bars to each and every point in my graph. How
do I do it? In particular I want to show the error of my dependent variable
y. Each one of which has an associated error which I have calculated by
taking the std deviation.

Thanks
Alex

B. R.Ramachandran

Error bars
 
Hi Alex,

If you are using Excel 2007:
Select the graph by clicking anywhere inside.
"Layout" tab -- "Error Bars" -- "More Error Bars Options" -- "Custom"
radio button and "Specify Value" rectangular button -- Select the cell range
containing the error values for "Positive Error Value" and "Negative Error
Value" (the same range can serve for both) -- "OK" -- "Close"

If error bars are created for both dependent and independent variables,
click on a horizontal error bar, right click and delete.

If this helps, please give a feedback by clicking "Yes".

Regards,
B. R. Ramachandran





"alex" wrote:

I wish to add different error bars to each and every point in my graph. How
do I do it? In particular I want to show the error of my dependent variable
y. Each one of which has an associated error which I have calculated by
taking the std deviation.

Thanks
Alex



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com