Chart independent from its Data Source

[Amr Tabbarah]

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?

 

[Paul B]

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]

Thank you Paul.

Your suggestion is working fine.


Amr