Michael -

This is one of the problems with charting in Excel 2007. I see no way within
the built in user interface to handle error bars any more easily than you've
found. To alleviate this and other issues, I've started designing my own set
of dialogs for editing charts. This is a nights and weekends kind of effort,
so it won't be available too soon, unfortunately.

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


"mwildt" wrote in message
...
Hi,

How can the task of adding 'error bars' to a graph be simplified with
excel
2007. In excel 2003 it is done way easier, almost just by double clicking
the
graph. In the 2007 version you have to walk through menus and then more
menus
to get the task done. When one has to do this for 40 graphs then the 2007
way
quickly becomes a huge hassle.

Any way to make excel 2007 as easy to use as excel 2003 for this
particular
feature ? (maybe with a macro or some other way to get this added to the
'right' click menu somehow)

Thanks,
Michael