"Moily" wrote in message
...
Can't do this as Charts are already there and depend on very different
data -
i'd have to go back and change the source data for each.

Not if you copy the first chart, select the second chart, and use Paste
Special - Formats.

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