Thread: Pasting excel sheets with charts

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?