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

[april]

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?

[vandenberg p]

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

april <april@discussions.microsoft.com> wrote:
: 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?

[april]

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
>
> april <april@discussions.microsoft.com> wrote:
> : 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?
>

[vandenberg p]

Given your warm endorsement I will be sure to respond quicker next time. Not!

Pieter Vandenberg


april <april@discussions.microsoft.com> wrote:
: 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
:>
:> april <april@discussions.microsoft.com> wrote:
:> : 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?
:>

[Jon Peltier]

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


"vandenberg p" <pavberg@rohan.sdsu.edu> wrote in message
news:dq9g54$9fp$1@gondor.sdsu.edu...
> 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
>
> april <april@discussions.microsoft.com> wrote:
> : 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?

[Jon Peltier]

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



"april" <april@discussions.microsoft.com> wrote in message
news:3224BB4C-7088-43C1-9BB6-4909B6684A46@microsoft.com...
>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
>>
>> april <april@discussions.microsoft.com> wrote:
>> : 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?
>>

[vandenberg p]

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


Jon Peltier <jonxlmvpREMOVE@capspeltiertech.com> wrote:
: 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/
: _______


: "vandenberg p" <pavberg@rohan.sdsu.edu> wrote in message
: news:dq9g54$9fp$1@gondor.sdsu.edu...
:> 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
:>
:> april <april@discussions.microsoft.com> wrote:
:> : 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?

[Jon Peltier]

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


"vandenberg p" <pavberg@rohan.sdsu.edu> wrote in message
news:dqc3v5$38u$1@gondor.sdsu.edu...
> 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
>
>
> Jon Peltier <jonxlmvpREMOVE@capspeltiertech.com> wrote:
> : 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/
> : _______
>
>
> : "vandenberg p" <pavberg@rohan.sdsu.edu> wrote in message
> : news:dq9g54$9fp$1@gondor.sdsu.edu...
> :> 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
> :>
> :> april <april@discussions.microsoft.com> wrote:
> :> : 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?
>
>