How do I copy an Excel chart to paste into InDesign?

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

Guest

I have a chart in MS Excel 2000 and when I select it, copy it, and then paste
it into InDesign CS2, the labels on the lower horizontal axis do not come
along. Is there some special way to do this that I'm missing?
 
1. Are you pasting into a frame? If so the default setting is to crop
the graphic. You may just be cropping the bottom.

2. My experience is that axis labels in Excel sometime do not transfer
well. My solution is to leave all labels blank, along with the chart
title and use Indesign to label chart.

3. If you wish you can try and see if you can export the chart to
a jpg or gif and perhaps that will import better.

Here is a link that will tell you how:
http://support.microsoft.com/kb/q163103/

Pieter Vandenberg

: I have a chart in MS Excel 2000 and when I select it, copy it, and then paste
: it into InDesign CS2, the labels on the lower horizontal axis do not come
: along. Is there some special way to do this that I'm missing?
 
I copied the graph into Illustrator and exported it as an .eps file which
goes into InDesign very nicely. Your ideas were to little too late. Thanks
anyway.
 
Given your warm endorsement I will be sure to respond quicker next time. Not!

Pieter Vandenberg


: I copied the graph into Illustrator and exported it as an .eps file which
: goes into InDesign very nicely. Your ideas were to little too late. Thanks
: anyway.

: "vandenberg p" wrote:

:> 1. Are you pasting into a frame? If so the default setting is to crop
:> the graphic. You may just be cropping the bottom.
:>
:> 2. My experience is that axis labels in Excel sometime do not transfer
:> well. My solution is to leave all labels blank, along with the chart
:> title and use Indesign to label chart.
:>
:> 3. If you wish you can try and see if you can export the chart to
:> a jpg or gif and perhaps that will import better.
:>
:> Here is a link that will tell you how:
:> http://support.microsoft.com/kb/q163103/
:>
:> Pieter Vandenberg
:>
:> : I have a chart in MS Excel 2000 and when I select it, copy it, and then paste
:> : it into InDesign CS2, the labels on the lower horizontal axis do not come
:> : along. Is there some special way to do this that I'm missing?
:>
 
Probably even easier is to hold Shift while selecting Copy Picture from the
Edit menu (Shift changes Copy to Copy Picture). Experiment with the options
until you find the set that work best; in general I prefer "on screen" and
"picture" for most purposes. Probably InDesign doesn't handle OLE objects
properly, but I'd think a metafile (i.e., picture) would work best.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Your ideas were to little too late.

Keep in mind that responses are not made by Microsoft employees, but by
well-meaning (and busy) volunteers who are offering their time and expertise
free of charge.

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

Actually it does for me, I had no trouble pasting an Excel chart into
InDesign. Either way worked for me, so I think there was something strange
about the way she was doing it or about the chart itself. Actually,
I have had trouble with Excel axis labels from time to time even
pasting into Powerpoint, using either direct paste or the shift paste.
Sometimes they get cut-off, other times the text becomes pixelated.
I think it might be related to resizing the plot area itself, but I
am not sure about that.


Pieter Vandenberg


: Probably even easier is to hold Shift while selecting Copy Picture from the
: Edit menu (Shift changes Copy to Copy Picture). Experiment with the options
: until you find the set that work best; in general I prefer "on screen" and
: "picture" for most purposes. Probably InDesign doesn't handle OLE objects
: properly, but I'd think a metafile (i.e., picture) would work best.

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


: :> 1. Are you pasting into a frame? If so the default setting is to crop
:> the graphic. You may just be cropping the bottom.
:>
:> 2. My experience is that axis labels in Excel sometime do not transfer
:> well. My solution is to leave all labels blank, along with the chart
:> title and use Indesign to label chart.
:>
:> 3. If you wish you can try and see if you can export the chart to
:> a jpg or gif and perhaps that will import better.
:>
:> Here is a link that will tell you how:
:> http://support.microsoft.com/kb/q163103/
:>
:> Pieter Vandenberg
:>
:> : I have a chart in MS Excel 2000 and when I select it, copy it, and then
:> paste
:> : it into InDesign CS2, the labels on the lower horizontal axis do not
:> come
:> : along. Is there some special way to do this that I'm missing?
 
Pieter -

I don't know why the labels are cut off, I don't think I've heard about
that. Sometimes the Y axis title gets truncated, and the only workaround
besides tweaking the screen resolution, font and font size, and window zoom,
is to use a couple spaces and a non-breaking space (get this character by
hold ALT while typing 0160 on the numeric keypad).

If the images become pixilated, then it's been converted to a bitmap rather
than a metafile ("picture" format I mentioned in my post).

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