PC Review


Reply
Thread Tools Rate Thread

Copy Chart issue

 
 
=?Utf-8?B?Q2FybG8=?=
Guest
Posts: n/a
 
      20th Sep 2006
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
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      20th Sep 2006
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" <(E-Mail Removed)> wrote in message
newsD312FB0-36EB-4386-97B8-(E-Mail Removed)...
> 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



 
Reply With Quote
 
=?Utf-8?B?Q2FybG8=?=
Guest
Posts: n/a
 
      21st Sep 2006
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" <(E-Mail Removed)> wrote in message
> newsD312FB0-36EB-4386-97B8-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy chart formatting and chart templates in Excel 2007 Astelix Microsoft Excel Charting 4 4th Mar 2010 05:10 AM
How do you link chart source data when you copy the chart? =?Utf-8?B?bWFtYWdpcmw=?= Microsoft Excel Charting 1 8th Dec 2006 03:40 AM
Embedded Chart Versus Chart - ShowDetail Issue james.igoe@gmail.com Microsoft Excel Discussion 1 14th May 2006 05:11 PM
Embedded Chart Versus Chart - ShowDetail Issue james.igoe@gmail.com Microsoft Excel Charting 1 14th May 2006 05:11 PM
Copy Data from Chart to Chart =?Utf-8?B?S2FyZW4=?= Microsoft Excel Charting 4 11th Jun 2004 05:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:00 PM.