PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?SmFja3Jj?=
Guest
Posts: n/a
 
      9th May 2006
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.
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      9th May 2006
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" <(E-Mail Removed)> wrote in message
news:F7A5F73D-D43E-4235-9DAE-(E-Mail Removed)...
> 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.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get my sizing handles back? Graph/data on same page. Dawn Microsoft Excel Charting 1 12th Mar 2010 12:44 PM
Copy Column data to Page Header DavidH56 Microsoft Excel Programming 7 14th Aug 2008 05:16 PM
Copy web data entry page into Excel =?Utf-8?B?QnJhZGxleSBa?= Microsoft Excel Misc 1 24th Oct 2006 03:49 PM
Copy data from excel into a web page. =?Utf-8?B?R3JhaGFt?= Microsoft Excel Programming 3 10th Dec 2004 07:34 PM
Restore added data in Data Grid in a Page When the page is reloaded krian Microsoft ASP .NET 1 12th Nov 2003 10:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:37 AM.