I had a VBA procedure which ran when the cells changed. It was fired by the
Worksheet_Change event. So it wasn't done automatically within the Excel UI,
but it was done automatically with a little help from VBA.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
wrote in message
oups.com...
The orientation cannot be done automatically, but I had a project which
would update the label orientation whenever the chart source data
changed.
- Jon
From the two points I can calculate the angle for the label ...
How did you change the label orientation to match the source data?
(you say it cannot be automatic but then say
'update ...orientation'?).
Steve