Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Custom Error Bars
I don't have a solution, but I wanted to mention I'm having exactly the same
problem. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Custom Lists in Excel | Excel Discussion (Misc queries) |