Excel to PowerPoint

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are making poster in PowerPoint using the data charts summarized in Excel.

We have 6 chart (all in the same sheet), I align them according to the x axis (the all have the same scale of x axis), and group them as one object.
But when I insert that object in PowerPoint, I lost the alignment.
In another word, What I see in Excel is different from what I get in PowerPoint.

On the other hand, If I just insert 6 charts into PowerPoint, and then align them in PowerPoint, the font of each chart change differently and it looks bad.

What I can do to keep both charts alignment and font size?
 
Terry -

You're in strange territory. Funny things can happen when you transfer
charts between Excel and PowerPoint. If you don't need to edit the
charts as charts in PowerPoint, you will have better luck copying the
charts as a picture in Excel. I notice however that any way I copy and
paste the charts as a group, the resulting group in PowerPoint doesn't
fit together anymore. Each individual chart has been shrunk within its
outline, so two adjacent charts no longer butt against each other.

You have two options. The first will prevent all the fonts from goofing
up too badly in PowerPoint. In Excel, double click each text element in
a chart, and on the Font tab, uncheck the Autoscale box. Then when you
readjust things in PowerPoint, at least the fonts will stop resizing.

The other is to copy the charts in Excel as pictures. Select the chart,
then hold Shift while clicking on the Edit menu, and choose Copy
Picture. Choose the On Screen and Picture options. Then arrange these
how you need them, group and copy, then paste into PowerPoint. You can
ungroup them and move by a pixel or so, but that's about all you should
need.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top