How do I copy a graph of a data page to a new data page.

[Jackrc]

Excel will not copy or move a set of graphs of one data page and let me set
the data source to another data page. It says it has a problem and closes
without saving the excel file.

 

[Jon Peltier]

I can't comment on the error. But a better way to make a second page with
data and charts that look the same as a first page, is to copy the whole
first page, so the copied charts link to the data on the copied sheet, and
then copy/paste special values or formulas the new data over the data on the
copied sheet. It's much easier to paste a whole bunch of data than to change
the data source on a whole bunch of charts.

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