Older versions of excel allowed us to click on a bar and drag it. The data
table automatically updated. Is there a trick to get a similar capability in
2007.

I wrote a macro that changed the data by clicking on the bar then clicking
on directional buttons. Doing this in front of an audience is much riskier
than clicking and dragging.

The trick is not to use 2007, because they've removed that capability.

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


"MikeT" wrote in message
...
Older versions of excel allowed us to click on a bar and drag it. The
data
table automatically updated. Is there a trick to get a similar capability
in
2007.

I wrote a macro that changed the data by clicking on the bar then clicking
on directional buttons. Doing this in front of an audience is much
riskier
than clicking and dragging.