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

RE: Advice on pasting charts from Excel to Powerpoint please by kathyATcreativetemplatesolutionsDOTcom>

kathyATcreativetemplatesolutionsDOTcom>
Thu Mar 13 09:17:02 CDT 2008

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.
--
Kathy Kensche
http://www.creativetemplatesolutions.com
London


"BarbaraF" wrote:

> 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
>
>

RE: Advice on pasting charts from Excel to Powerpoint please by BarbaraF

BarbaraF
Thu Mar 13 10:23:02 CDT 2008

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" wrote:

> 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.
> --
> Kathy Kensche
> http://www.creativetemplatesolutions.com
> London
>
>
> "BarbaraF" wrote:
>
> > 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
> >
> >

RE: Advice on pasting charts from Excel to Powerpoint please by kathyATcreativetemplatesolutionsDOTcom>

kathyATcreativetemplatesolutionsDOTcom>
Thu Mar 13 16:58:01 CDT 2008

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

--
Kathy Kensche
http://www.creativetemplatesolutions.com
London


"BarbaraF" wrote:

> 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" wrote:
>
> > 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.
> > --
> > Kathy Kensche
> > http://www.creativetemplatesolutions.com
> > London
> >
> >
> > "BarbaraF" wrote:
> >
> > > 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
> > >
> > >