Excel 2007 Custom Error Bars
I cannot seem to get custom error bars to work on charts in excel 2007. I
have a set of data, eight numerical y values, and each one has a different standard deviation. I plot a histogram and use custom error bars selecting +/- my deviations from the worksheet (which are approx 10% of numerical value so easy to see) and then click ok but nothing appears on my chart just two circles (doing the same in excel 2003 works fine, I see them fine). If I create the error bars in excel 2003 and open them in 2007 they appear and when I go into custom error bars the correct worksheet cells appear, however if I click ok they dissapear (clicking cancel they remain). Its infuriating! Any suggestions? |
Excel 2007 Custom Error Bars
I don't have a solution, but I wanted to mention I'm having exactly the same
problem. |
Excel 2007 Custom Error Bars
Same here. I'd also like to point out that if I open a 2003 file with a
chart containing error bars, the Y axis gets re-sized to fit the data points only, cutting off any large error bars. |
Excel 2007 Custom Error Bars
Same here as well. Any solutions yet?
"DrNik" wrote: Same here. I'd also like to point out that if I open a 2003 file with a chart containing error bars, the Y axis gets re-sized to fit the data points only, cutting off any large error bars. |
Excel 2007 Custom Error Bars
Same here... waiting for solution.
if you guy has a solution please post it here. Thank "BuzzinHornet" wrote: I cannot seem to get custom error bars to work on charts in excel 2007. I have a set of data, eight numerical y values, and each one has a different standard deviation. I plot a histogram and use custom error bars selecting +/- my deviations from the worksheet (which are approx 10% of numerical value so easy to see) and then click ok but nothing appears on my chart just two circles (doing the same in excel 2003 works fine, I see them fine). If I create the error bars in excel 2003 and open them in 2007 they appear and when I go into custom error bars the correct worksheet cells appear, however if I click ok they dissapear (clicking cancel they remain). Its infuriating! Any suggestions? |
All times are GMT +1. The time now is 03:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com