+ Reply to Thread
Results 1 to 5 of 5

Paste a Rotated Chart into Word from Excel

  1. #1
    Registered User
    Join Date
    11-20-2007
    Location
    Wales
    MS-Off Ver
    2013
    Posts
    31

    Paste a Rotated Chart into Word from Excel

    I'm trying to put a line chart I have created in excel 2013 into a word 2013 document. I need to use paste special and link the chart as it's for a journal and all the paste picture options make the chart look blurry. So far I have managed to paste the link into a textbox and after much faffing around have rotated the chart and got the size about right but I have a grey boarder surrounding my chart that I can not get rid of. There is no boarder in the original excel chart but if I add one in the excel chart it appears in exactly the same place as the grey boarder I want to remove. Can anyone shed any light on either a better way to get a crisp image of my chart into a word document and rotate it by 90 degrees or remove the grey boarder lines?

    Thanks

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Paste a Rotated Chart into Word from Excel

    can you provide a sample of the document? have you tried removing the border in Word?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    11-20-2007
    Location
    Wales
    MS-Off Ver
    2013
    Posts
    31

    Re: Paste a Rotated Chart into Word from Excel

    Yes, there is also no boarder in the word document.

    I think I have uploaded attachments for the original excel file and the word document I am having problems with.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-20-2007
    Location
    Wales
    MS-Off Ver
    2013
    Posts
    31

    Re: Paste a Rotated Chart into Word from Excel

    Is it possible to remove the grey boarder?

  5. #5
    Registered User
    Join Date
    03-30-2014
    Location
    Pittsburgh,PA
    MS-Off Ver
    Office 2010, Home Student 2013
    Posts
    62

    Re: Paste a Rotated Chart into Word from Excel

    Try this. I don't think you need a rotated text box to hold the chart.

    Instead of rotating the chart in Word, rotate the Word document page to landscape, then paste.

    Switch to layout view.
    At the end of the page before the page where the chart is to be pasted, insert a section/page break.
    From the next page, click on the 'Page Layout' tab on the ribbon.
    In the lower right corner of the Page Setup section is a tiny right angle with arrow icon. Click on this to icon to bring up the 'Page Setup' dialog.

    NexZNa1.jpg

    On the 'Margin' tab of the 'Page Setup' window, change the 'orientation' to Landscape', and at the bottom of this tab, change 'Applies to:' from 'Whole document' to 'This point forward'. Click OK.

    Copy your chart from Excel, and paste it on the landscape oriented page with Ctrl+V.

    Insert a new section/page break after the chart and change the page orientation back to letter from 'This point forward'.

    Link: https://www.dropbox.com/s/oigmdoolgr...dscp.docx?dl=0

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. can not paste special my excel chart to word
    By ACrossley1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-24-2016, 06:25 AM
  2. copy a chart in excel and paste it in word with defined size by vba programming
    By afshingivi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2016, 12:32 AM
  3. copy and paste excel chart to word
    By treader in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2015, 10:56 AM
  4. Replies: 7
    Last Post: 09-17-2014, 03:01 PM
  5. Unable to change properties when I paste chart from excel to word
    By rolta100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2013, 07:55 AM
  6. [SOLVED] Distorted Excel chart fonts when copy/paste to Word or Powerpoint
    By JJMB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-18-2006, 02:45 PM
  7. Copy and paste Excel chart in Word --> font compresses
    By ScooterGirl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-09-2006, 11:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1