linked chart within a file

[DavidF]

I have a worksheet with data and several charts.

I'd like to have an additional worksheet with copies of those charts that
are linked and updated whenever the charts on the first worksheet are. I
think this will make it easier for me to make the acrobat files I want.

I can't seem to 'paste special' and don't have any other ideas.

Any advice appreciated!

david

 

[Dave Peterson]

You could copy the chart and paste it onto another worksheet.

Or you could select a little bit of the range surrounding the chart (include the
chart).

Then go to the other sheet and Edit|Paste picture link