I am trying to paste an excel sheet that contains 5 charts, into another
excel workbook to send to another user. I am not including the data sources,
just the charts. When I open it, the formats have changed. I am breaking
the links, because the other users do not have the data. I just want them to
have the charts in the same format I see them.

Any ideas?

One way to do it would be to copy each chart as a picture
select the chart
(hold down the shift key)<Edit <Copy as picture
Paste each of the pictures into a empty workbook and send this workbook
one of the advantages of this is that the data is not sent with the graph.

"Duane" wrote:

I am trying to paste an excel sheet that contains 5 charts, into another
excel workbook to send to another user. I am not including the data sources,
just the charts. When I open it, the formats have changed. I am breaking
the links, because the other users do not have the data. I just want them to
have the charts in the same format I see them.

Any ideas?