Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I do different error bars within a series?
I have two sets of data, and have used the mean to make a column chart. I now
need to add standard deviation error bars, which will be different for each mean. The only way I have seen to do this so far is by switching the data over the axis (ie, clicking "Switch row/column") but this clumps my bars together and gets rid of the axis labels for the two columns. Is there a way to get different error bars without doing this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I do different error bars within a series?
Hi,
You did not say what version of Excel you are using - Select the series and choose Format, Selected Data Series, Y - Error Bars, choose the Standard Deviation option. Repeat for the other series. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Helen" wrote: I have two sets of data, and have used the mean to make a column chart. I now need to add standard deviation error bars, which will be different for each mean. The only way I have seen to do this so far is by switching the data over the axis (ie, clicking "Switch row/column") but this clumps my bars together and gets rid of the axis labels for the two columns. Is there a way to get different error bars without doing this? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I do different error bars within a series?
Thanks, but I'm using 2007. Sorry I forgot to say that! If I'm right, the
explanation given works on earlier versions but not 2007. Wish I'd bought an older version now! Helen "Shane Devenshire" wrote: Hi, You did not say what version of Excel you are using - Select the series and choose Format, Selected Data Series, Y - Error Bars, choose the Standard Deviation option. Repeat for the other series. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Helen" wrote: I have two sets of data, and have used the mean to make a column chart. I now need to add standard deviation error bars, which will be different for each mean. The only way I have seen to do this so far is by switching the data over the axis (ie, clicking "Switch row/column") but this clumps my bars together and gets rid of the axis labels for the two columns. Is there a way to get different error bars without doing this? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I do different error bars within a series?
Yeah, 2007 makes it harder. Select the series, go to the middle of the three
chart contextual tabs, find the error bars button, drop it down, choose the little item at the very bottom (not one of the four lame options which are visible). In the dialog, select the custom radio button, then click on the button that becomes enabled, and select your range(s). Did I say ranges? The best thing to do is calculate your error bar values in the worksheet, and use these as the source data for the custom error bars. I'm working on an article actually on Excel 2007 error bars, which should be posted to my blog tomorrow. Assuming it is finished on time, it will be posted at: http://peltiertech.com/WordPress/200...in-excel-2007/ It will include a small free utility that makes error bars just a little bit easier in Excel 2003 and a whole lot easier in 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Helen" wrote in message ... Thanks, but I'm using 2007. Sorry I forgot to say that! If I'm right, the explanation given works on earlier versions but not 2007. Wish I'd bought an older version now! Helen "Shane Devenshire" wrote: Hi, You did not say what version of Excel you are using - Select the series and choose Format, Selected Data Series, Y - Error Bars, choose the Standard Deviation option. Repeat for the other series. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Helen" wrote: I have two sets of data, and have used the mean to make a column chart. I now need to add standard deviation error bars, which will be different for each mean. The only way I have seen to do this so far is by switching the data over the axis (ie, clicking "Switch row/column") but this clumps my bars together and gets rid of the axis labels for the two columns. Is there a way to get different error bars without doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I incorporate SD from a data series into chart error bars? | Charts and Charting in Excel | |||
off-setting points of different series b/c error bars overlap | Charts and Charting in Excel | |||
How do I set different error bars per data point in a series | Charts and Charting in Excel | |||
Error bars for a single data point not whole series | Charts and Charting in Excel | |||
format one data series, with error bars, and use it as default | Charts and Charting in Excel |