View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Custom error bars excel 2007

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?