copy and pasting dynamic charts

[Cal@tech-etch]

Is it possible to copy and paste a dynamic chart to reflect a differant data
range without having to difine names to reflect the new data series.

Cal

 

[Jon Peltier]

If you don't define new data, the chart can only display the old data.

One thing you could do is open a copy of the workbook, and paste the new data (use
paste special-values) on top of the old.

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