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?

I don't have a solution, but I wanted to mention I'm having exactly the same
problem.

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.

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.

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?