Copied chart should link to the new work sheet

[Guest]

It would be useful if EXCEL could allow copied chart from a work sheet and
link the data from the new work sheet but keep the chart format. For example,
copy the whole work sheet (with a chart). Then creat a new work sheet. Then
paste the copied whork sheet (with a chart) to the created work sheet.
Currently, the chart in the new work sheet is still linked to the original
work sheet. It could be useful if the pasted chart is linked to the data in
the newly created work sheet.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-ba5d-e310cefa4ce6&dg=microsoft.public.access

 

[Douglas J. Steele]

You might want to repost this to a newsgroup that's related to Excel.

This newsgroup is for discussion of Access, the database product that's part
of Office Professional.