Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point or be able to specify only vertical error bars instead of both (horizontal and vertical) or none. How can I add only vertical error bars to a single data point in a series in Excel 2007? Thanks, Chris |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Chris,
I could not follow you URL since you abbreviated it - why not cut and paste? This one is specific to XL2007 http://office.microsoft.com/en-ca/he...074621033.aspx I simply make the chart with both vertical and horizontal error bars then deleted the horizontal best wises -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Chris Wagner, Northern Michigan Univ." soft.com wrote in message ... Hi, I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point or be able to specify only vertical error bars instead of both (horizontal and vertical) or none. How can I add only vertical error bars to a single data point in a series in Excel 2007? Thanks, Chris |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Bernard -
Google does that to the URLs, supposedly for privacy or whatever, but I find it a PITA. I think that the OP wanted an error bar on a single point. To do this, you need a range for error bar values, with all cells blank except the value for the particular point. Using the Custom setting for error bar values, select the range, so that the value lines up with the point you want, and zeros line up with the rest. I don't know why they made it so hard to add the error bars you want to series in Excel 2007. In the new version you have to add the whole bunch, then remove what you don't want. It took me like an hour to figure this out, and I don't think I'm a newbie at charting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... Chris, I could not follow you URL since you abbreviated it - why not cut and paste? This one is specific to XL2007 http://office.microsoft.com/en-ca/he...074621033.aspx I simply make the chart with both vertical and horizontal error bars then deleted the horizontal best wises -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Chris Wagner, Northern Michigan Univ." soft.com wrote in message ... Hi, I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point or be able to specify only vertical error bars instead of both (horizontal and vertical) or none. How can I add only vertical error bars to a single data point in a series in Excel 2007? Thanks, Chris |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Thanks. Deleting the horizontal error bars and using a range will all the error values at zero except for the datapoints I wanted the vertical error bars for worked. Kind of an odd solution but it works. Thanks, Chris "Jon Peltier" wrote: Bernard - Google does that to the URLs, supposedly for privacy or whatever, but I find it a PITA. I think that the OP wanted an error bar on a single point. To do this, you need a range for error bar values, with all cells blank except the value for the particular point. Using the Custom setting for error bar values, select the range, so that the value lines up with the point you want, and zeros line up with the rest. I don't know why they made it so hard to add the error bars you want to series in Excel 2007. In the new version you have to add the whole bunch, then remove what you don't want. It took me like an hour to figure this out, and I don't think I'm a newbie at charting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... Chris, I could not follow you URL since you abbreviated it - why not cut and paste? This one is specific to XL2007 http://office.microsoft.com/en-ca/he...074621033.aspx I simply make the chart with both vertical and horizontal error bars then deleted the horizontal best wises -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Chris Wagner, Northern Michigan Univ." soft.com wrote in message ... Hi, I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point or be able to specify only vertical error bars instead of both (horizontal and vertical) or none. How can I add only vertical error bars to a single data point in a series in Excel 2007? Thanks, Chris |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi when I click on Custom Error Bars a dialog box comes up that lets me
choose the range of cells to use, but when I click on a worksheet the dialog box disappears. I can't think of any easy way to input the range of cells, other than copying =Sheet1!$.... Does the dialog box disappear for anyone else? "Jon Peltier" wrote: Bernard - Google does that to the URLs, supposedly for privacy or whatever, but I find it a PITA. I think that the OP wanted an error bar on a single point. To do this, you need a range for error bar values, with all cells blank except the value for the particular point. Using the Custom setting for error bar values, select the range, so that the value lines up with the point you want, and zeros line up with the rest. I don't know why they made it so hard to add the error bars you want to series in Excel 2007. In the new version you have to add the whole bunch, then remove what you don't want. It took me like an hour to figure this out, and I don't think I'm a newbie at charting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... Chris, I could not follow you URL since you abbreviated it - why not cut and paste? This one is specific to XL2007 http://office.microsoft.com/en-ca/he...074621033.aspx I simply make the chart with both vertical and horizontal error bars then deleted the horizontal best wises -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Chris Wagner, Northern Michigan Univ." soft.com wrote in message ... Hi, I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point or be able to specify only vertical error bars instead of both (horizontal and vertical) or none. How can I add only vertical error bars to a single data point in a series in Excel 2007? Thanks, Chris |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The dialog may not be disappearing, but shrinking and moving either to a
place you don't notice it, or even off screen somewhere. I'm not sure how to bring it back to a useful position. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "AaronX" wrote in message ... Hi when I click on Custom Error Bars a dialog box comes up that lets me choose the range of cells to use, but when I click on a worksheet the dialog box disappears. I can't think of any easy way to input the range of cells, other than copying =Sheet1!$.... Does the dialog box disappear for anyone else? "Jon Peltier" wrote: Bernard - Google does that to the URLs, supposedly for privacy or whatever, but I find it a PITA. I think that the OP wanted an error bar on a single point. To do this, you need a range for error bar values, with all cells blank except the value for the particular point. Using the Custom setting for error bar values, select the range, so that the value lines up with the point you want, and zeros line up with the rest. I don't know why they made it so hard to add the error bars you want to series in Excel 2007. In the new version you have to add the whole bunch, then remove what you don't want. It took me like an hour to figure this out, and I don't think I'm a newbie at charting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... Chris, I could not follow you URL since you abbreviated it - why not cut and paste? This one is specific to XL2007 http://office.microsoft.com/en-ca/he...074621033.aspx I simply make the chart with both vertical and horizontal error bars then deleted the horizontal best wises -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Chris Wagner, Northern Michigan Univ." soft.com wrote in message ... Hi, I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. http://office.microsoft.com/en-us/ex...x#AddErrorBars is worded in a way that sounds like it is possible to do that in Excel 2007 yet I don't appear to have the option in the properties for a particular data point or be able to specify only vertical error bars instead of both (horizontal and vertical) or none. How can I add only vertical error bars to a single data point in a series in Excel 2007? Thanks, Chris |
#7
![]() |
|||
|
|||
![]()
Hi Chris,
Yes, it is possible to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007. Here are the steps to do so:
That's it! You have now added only vertical error bars to a single data point in a series on a scatter chart in Excel 2007.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add different error bars to each data point in excel | Charts and Charting in Excel | |||
Single Data Point on a new Series | Charts and Charting in Excel | |||
How do I add error bars unique to each data point? | 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 |