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 pictu 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" wrote in message
...
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