![]() |
How do I copy a graph of a data page to a new data page.
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. |
How do I copy a graph of a data page to a new data page.
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/ _______ "Jackrc" wrote in message ... 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. |
All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com