ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I copy a graph of a data page to a new data page. (https://www.excelbanter.com/charts-charting-excel/87532-how-do-i-copy-graph-data-page-new-data-page.html)

Jackrc

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.

Jon Peltier

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