Custom error bars excel 2007

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>>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?
>
>