Copy Chart issue

Hi all

i'm trying to copy a chart to word, which i managed to do!
Now the problem is, the y-axis of the chart in excel is:
2001;2002;.....;2006
after copy and pasting into word it only is:
20;20;....;20
I ungrouped the chart and found out, that word doesn't cut
the textbox around the year but just receives the 2 digits i see!

any advice?

Thanks in advance

Carlo

1. Make the chart in Excel the right size for the space in Word.
2. Copy the chart as a picture: hold shift, select the Edit menu, choose
Copy Picture, then use the On Screen and Picture options.
3. Paste as normal into Word.

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


"Carlo" <Carlo@discussions.microsoft.com> wrote in message
newsD312FB0-36EB-4386-97B8-C6DF76E67247@microsoft.com...
> Hi all
>
> i'm trying to copy a chart to word, which i managed to do!
> Now the problem is, the y-axis of the chart in excel is:
> 2001;2002;.....;2006
> after copy and pasting into word it only is:
> 20;20;....;20
> I ungrouped the chart and found out, that word doesn't cut
> the textbox around the year but just receives the 2 digits i see!
>
> any advice?
>
> Thanks in advance
>
> Carlo

Morning Jon (As it is 8 o'clock here )

Thanks a lot, it worked perfectly.

Carlo

"Jon Peltier" wrote:

> 1. Make the chart in Excel the right size for the space in Word.
> 2. Copy the chart as a picture: hold shift, select the Edit menu, choose
> Copy Picture, then use the On Screen and Picture options.
> 3. Paste as normal into Word.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Carlo" <Carlo@discussions.microsoft.com> wrote in message
> newsD312FB0-36EB-4386-97B8-C6DF76E67247@microsoft.com...
> > Hi all
> >
> > i'm trying to copy a chart to word, which i managed to do!
> > Now the problem is, the y-axis of the chart in excel is:
> > 2001;2002;.....;2006
> > after copy and pasting into word it only is:
> > 20;20;....;20
> > I ungrouped the chart and found out, that word doesn't cut
> > the textbox around the year but just receives the 2 digits i see!
> >
> > any advice?
> >
> > Thanks in advance
> >
> > Carlo
>
>
>