software

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:
support.microsoft.com/kb/q163103/

Pieter Vandenberg

april gt; 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?

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.

quot;vandenberg pquot; wrote:

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

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

Pieter Vandenbergapril gt; 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.

: quot;vandenberg pquot; wrote:

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

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 quot;on screenquot; and
quot;picturequot; 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
PeltierTech.com/
_______quot;vandenberg pquot; gt; wrote in message
...
gt; 1. Are you pasting into a frame? If so the default setting is to crop
gt; the graphic. You may just be cropping the bottom.
gt;
gt; 2. My experience is that axis labels in Excel sometime do not transfer
gt; well. My solution is to leave all labels blank, along with the chart
gt; title and use Indesign to label chart.
gt;
gt; 3. If you wish you can try and see if you can export the chart to
gt; a jpg or gif and perhaps that will import better.
gt;
gt; Here is a link that will tell you how:
gt; support.microsoft.com/kb/q163103/
gt;
gt; Pieter Vandenberg
gt;
gt; april gt; wrote:
gt; : I have a chart in MS Excel 2000 and when I select it, copy it, and then
gt; paste
gt; : it into InDesign CS2, the labels on the lower horizontal axis do not
gt; come
gt; : along. Is there some special way to do this that I'm missing?
gt; 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
PeltierTech.com/
_______
quot;aprilquot; gt; wrote in message
...
gt;I copied the graph into Illustrator and exported it as an .eps file which
gt; goes into InDesign very nicely. Your ideas were to little too late. Thanks
gt; anyway.
gt;
gt; quot;vandenberg pquot; wrote:
gt;
gt;gt; 1. Are you pasting into a frame? If so the default setting is to crop
gt;gt; the graphic. You may just be cropping the bottom.
gt;gt;
gt;gt; 2. My experience is that axis labels in Excel sometime do not transfer
gt;gt; well. My solution is to leave all labels blank, along with the chart
gt;gt; title and use Indesign to label chart.
gt;gt;
gt;gt; 3. If you wish you can try and see if you can export the chart to
gt;gt; a jpg or gif and perhaps that will import better.
gt;gt;
gt;gt; Here is a link that will tell you how:
gt;gt; support.microsoft.com/kb/q163103/
gt;gt;
gt;gt; Pieter Vandenberg
gt;gt;
gt;gt; april gt; wrote:
gt;gt; : I have a chart in MS Excel 2000 and when I select it, copy it, and then
gt;gt; paste
gt;gt; : it into InDesign CS2, the labels on the lower horizontal axis do not
gt;gt; come
gt;gt; : along. Is there some special way to do this that I'm missing?
gt;gt;
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 VandenbergJon Peltier gt; 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 quot;on screenquot; and
: quot;picturequot; 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
: PeltierTech.com/
: _______: quot;vandenberg pquot; gt; wrote in message
: ...
:gt; 1. Are you pasting into a frame? If so the default setting is to crop
:gt; the graphic. You may just be cropping the bottom.
:gt;
:gt; 2. My experience is that axis labels in Excel sometime do not transfer
:gt; well. My solution is to leave all labels blank, along with the chart
:gt; title and use Indesign to label chart.
:gt;
:gt; 3. If you wish you can try and see if you can export the chart to
:gt; a jpg or gif and perhaps that will import better.
:gt;
:gt; Here is a link that will tell you how:
:gt; support.microsoft.com/kb/q163103/
:gt;
:gt; Pieter Vandenberg
:gt;
:gt; april gt; wrote:
:gt; : I have a chart in MS Excel 2000 and when I select it, copy it, and then
:gt; paste
:gt; : it into InDesign CS2, the labels on the lower horizontal axis do not
:gt; come
:gt; : 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 (quot;picturequot; format I mentioned in my post).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;vandenberg pquot; gt; wrote in message
...
gt; Jon:
gt;
gt; Actually it does for me, I had no trouble pasting an Excel chart into
gt; InDesign. Either way worked for me, so I think there was something strange
gt; about the way she was doing it or about the chart itself. Actually,
gt; I have had trouble with Excel axis labels from time to time even
gt; pasting into Powerpoint, using either direct paste or the shift paste.
gt; Sometimes they get cut-off, other times the text becomes pixelated.
gt; I think it might be related to resizing the plot area itself, but I
gt; am not sure about that.
gt;
gt;
gt; Pieter Vandenberg
gt;
gt;
gt; Jon Peltier gt; wrote:
gt; : Probably even easier is to hold Shift while selecting Copy Picture from
gt; the
gt; : Edit menu (Shift changes Copy to Copy Picture). Experiment with the
gt; options
gt; : until you find the set that work best; in general I prefer quot;on screenquot;
gt; and
gt; : quot;picturequot; for most purposes. Probably InDesign doesn't handle OLE
gt; objects
gt; : properly, but I'd think a metafile (i.e., picture) would work best.
gt;
gt; : - Jon
gt; : -------
gt; : Jon Peltier, Microsoft Excel MVP
gt; : Peltier Technical Services
gt; : Tutorials and Custom Solutions
gt; : PeltierTech.com/
gt; : _______
gt;
gt;
gt; : quot;vandenberg pquot; gt; wrote in message
gt; : ...
gt; :gt; 1. Are you pasting into a frame? If so the default setting is to crop
gt; :gt; the graphic. You may just be cropping the bottom.
gt; :gt;
gt; :gt; 2. My experience is that axis labels in Excel sometime do not transfer
gt; :gt; well. My solution is to leave all labels blank, along with the chart
gt; :gt; title and use Indesign to label chart.
gt; :gt;
gt; :gt; 3. If you wish you can try and see if you can export the chart to
gt; :gt; a jpg or gif and perhaps that will import better.
gt; :gt;
gt; :gt; Here is a link that will tell you how:
gt; :gt; support.microsoft.com/kb/q163103/
gt; :gt;
gt; :gt; Pieter Vandenberg
gt; :gt;
gt; :gt; april gt; wrote:
gt; :gt; : I have a chart in MS Excel 2000 and when I select it, copy it, and
gt; then
gt; :gt; paste
gt; :gt; : it into InDesign CS2, the labels on the lower horizontal axis do not
gt; :gt; come
gt; :gt; : along. Is there some special way to do this that I'm missing?
gt;
gt;