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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
Back
Top