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?

For discussions about Office 2007, you should go to the newsgroups on
BetaPlace.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"BuzzinHornet" wrote in message
...
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 apologize. Microsoft intends that users of the public beta use these
forums for discussion. My bad.

I have not tested the error bars yet in this beta version. Perhaps this
functionality is still being perfected.

Presumably you are running the beta on a spare computer, using test files,
and not on your main computer using important work files.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Jon Peltier" wrote in message
...
For discussions about Office 2007, you should go to the newsgroups on
BetaPlace.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"BuzzinHornet" wrote in message
...
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?