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.
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/
_______
"Jackrc" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks