PC Review


Reply
Thread Tools Rate Thread

Chart independent from its Data Source

 
 
Amr Tabbarah
Guest
Posts: n/a
 
      30th Oct 2003
When I make a Chart, it remains related to its Data Source.

I am trying to keep the Chart but do not want it to be dependent
anymore on its original Data Source. It is somewhat similar to
replacing an equation by its result.

Can anybody assist in finding a solution?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

 
Reply With Quote
 
 
 
 
Paul B
Guest
Posts: n/a
 
      30th Oct 2003
Amr, here is one way, you could copy a picture of the chart: Hold down Shift
while selecting the Edit menu, and choose the Copy Picture command. I like
the 'As Shown on Screen' and 'As Picture' options. Then just paste it where
you want it.

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Amr Tabbarah" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I make a Chart, it remains related to its Data Source.
>
> I am trying to keep the Chart but do not want it to be dependent
> anymore on its original Data Source. It is somewhat similar to
> replacing an equation by its result.
>
> Can anybody assist in finding a solution?
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>



 
Reply With Quote
 
Amr Tabbarah
Guest
Posts: n/a
 
      30th Oct 2003
Thank you Paul.

Your suggestion is working fine.


Amr



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

 
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
Provider independent data access: problem with Excel ODBC source =?Utf-8?B?SmltIFdhbHNo?= Microsoft ADO .NET 3 25th Apr 2007 05:41 PM
How do you link chart source data when you copy the chart? =?Utf-8?B?bWFtYWdpcmw=?= Microsoft Excel Charting 1 8th Dec 2006 02:40 AM
chart with changing data source interactive chart Feketik Microsoft Excel Charting 2 19th Mar 2004 09:26 AM
chart with changing data source interactive chart Feketik Microsoft Excel Charting 0 18th Mar 2004 04:34 PM
Chart Source Data Ranges Changing when Data Sheet updated from text file source. Tekn0 Microsoft Excel Charting 3 8th Jan 2004 04:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:34 PM.