Advice on pasting charts from Excel to Powerpoint please

[BarbaraF]

I have an Excel sheet which has several small charts already arranged side by
side. I just want to transfer them to a Powerpoint slide as a single simple
image, I don't need any links or updating.

I can select the area of the page with the charts, and then use copy and
paste-special. If I choose Picture (enhanced metafile), then some parts of
the image get changed, e.g. the background colour of the text in the legend
changes from grey to white. On the other hand, if I choose Bitmap, the image
comes through without changes, but looks a bit fuzzy, as if I need to
increase the resolution.

I'd be very grateful for any suggestions to get this working more smoothly,
Barbara

 

[Kathy Kensche]

In Excel, set your Printer to "PDF" or "Image Writer" or any other Colour
Printer that you have available (you don't need to print - just set it and
cancel out again).
Then highlight your area to be copied but then instead of Copy, hold Shift
and go "Edit-Copy Picture - as shown when printed". This will give you the
best output that Excel (being a non-graphical application) can give you.
This picture can then be pasted into PPT as is (you don't have to paste
special).

Hope this helps.

 

[BarbaraF]

Thanks, that certainly improves the appearance.

I haven't met SHIFT + EDIT menu before, is there somewhere I can read up
about any other useful aspects of this?

Barbara

 

[Kathy Kensche]

It's the only "sneaky" one that we use all the time for DTP purposes. For a
full list of shortcuts, have a look here:
http://office.microsoft.com/en-gb/excel/HP052037811033.aspx