Monday, July 10, 2017

Insert a chart from an Excel spreadsheet into Word

Insert a chart from an Excel spreadsheet into Word

The simplest way to insert a chart from an Excel spreadsheet into your Word document is to use the copy and paste commands.

Example of an Excel chart pasted into a Word doc

You can change the chart, update it, and redesign it without ever leaving Word. And if you change the data in Excel, you can automatically refresh the chart in Word.

If you'd rather create an Excel chart in Word from scratch, see Create an Excel chart in Word.

  1. In Excel, click the chart, and then press Ctrl+C or click Home > Copy.

  2. In your Word document, click where you want the chart to appear, and press Ctrl+C or click Home > Paste.

    Note: The chart is linked to the original Excel spreadsheet. If data in the spreadsheet changes, the chart updates automatically.

Update a chart

  1. Click the chart.

  2. On the Chart Tools Design tab, in the Data group, click Refresh Data.

You can change the design or data for a chart in Word.

Note: You can't edit a chart that was inserted as a picture, but you can adjust it. Click the chart, and then on the Picture Tools Format tab, in the Adjust group, choose an option.

  1. Click the chart.

  2. On the Chart Tools Design tab, in the Data group, in the Edit Data list, choose one of the following:

    • Choose Edit Data to edit the chart in Word.

    • Choose Edit Data in Excel.

You also can modify the chart in Word by using any of the four buttons that appear when you click the chart.

Image of an Excel chart pasted into a Word doc and four layout buttons

From top to bottom, the buttons are:

  • Layout Options
    Choose how your object interacts with the text around it.

  • Chart Elements
    Add, remove, or change chart elements such as the title, legend, gridlines, and data labels.

  • Chart Styles
    Set a style and color scheme for your chart.

  • Chart Filters
    Edit what data points and names are visible in your chart.

Click any button to view available options.

  1. Click the chart.

  2. On the Chart Tools Design tab, in the Data group, click Edit Data.

    Note: The chart opens in Excel for editing.

There are five options for pasting an Excel chart into Word. Two options embed a copy of the whole workbook, another two keep the chart linked to the original workbook instead of embedding it, and one converts the chart into a picture. If none of those options do exactly what you want, you also can click Paste Special.

From Excel

  • In Excel, click the chart you want to paste into Word, and then press Ctrl+C or click Home > Copy.

In Word

  • In Word, click Home, and in the Paste list, choose one of the five Paste Options.

    Button group of five options for pasting Excel charts into Word

Note: Hover over a button to read a description of the option.

Paste option

Color theme

Data refresh

Use Destination Theme & Embed Workbook

Matches the Word theme

Embeds a copy of the Excel workbook with the chart. The chart doesn't stay linked to the original workbook. To update the chart automatically, change the data in the embedded workbook.

Keep Source Formatting & Embed Workbook

Keeps the Excel theme

Embeds a copy of the Excel workbook with the chart. The chart doesn't stay linked to the original workbook. To update the chart automatically, change the data in the embedded workbook.

Use Destination Theme & Link Data

This is the default paste option (Ctrl+V).

Matches the Word theme

Keeps the chart linked to the original workbook. To update the chart automatically, change the data in the original workbook. You also can click Chart Tools > Design > Refresh Data.

Keep Source Formatting & Link Data

Keeps the Excel theme

Keeps the chart linked to the original workbook. To update the chart automatically, change the data in the original workbook. You also can click Chart Tools> Design > Refresh Data.

Picture

Becomes a picture

You can't update the data or edit the chart, but you can adjust the chart's appearance. Under Picture Tools, click Format.

The main differences between linked objects and embedded objects are where the data is stored and how you update the data after it's inserted in the Word document.

  • Linked object
    Information from a object that is linked in Word is stored in the source file and can be updated if the source file is modified. Use linked objects if file size is a consideration.

  • Embedded object
    Information from an Excel object that you embed in Word doesn't change if you modify the source Excel file. Once embedded, the object is no longer part of the source file and won't reflect any changes made.

  1. On the Insert tab, in the Text group, click Object.

  2. In the Object dialog box, on the Create from file tab, choose Browse, and locate the file you want to insert in the Word document.

  3. Choose one of the following:

    • To add the file as a linked object, select the Link to file check box, and then click OK.

    • To add the file as an embedded object, select the Display as icon check box, and then click OK.

You might find it necessary to open both your Excel worksheet and your Word document to carry out the procedure that follows.

  1. On the Insert tab, in the Text group, click Object,.

  2. In the Object dialog box, on the Create from file tab, choose Browse, and locate the file you want to insert in the Word document.

  3. Choose one of the following:

    • To add the file as a linked object, select the Link to file check box, and then click OK.

    • To add the file as an embedded object, select the Display as icon check box, and then click OK.

48 comments:

  1. Great post! I have definitely noted some points from post. They’re really convincing and will definitely work. It’s a great blog and I wish being a constant visitor to this page. Many thanks for sharing. visit maaun post utme past questions and answers

    ReplyDelete
  2. Nice Blog for Ireland Student. Assignment Help Ireland can play a vital role to help the Ireland students and reduce some burden. They will write all your assignments within the given time. You only need to tell them the requirements and pay the required amount.

    ReplyDelete




  3. Did you hear about Dramatic irony before? If not then here I gonna share with you fresh content on it. The dramatic irony comes from irony and has three types, situational irony, verbal and dramatic too. Let's understand its example Shakespeare's Romeo and Juliet, people think Juliet live but Romeo knows the reality.

    ReplyDelete
  4. Intrested blog I read some days every post is Good but this post is very helpful


    Action camera body mount

    ReplyDelete
  5. Great Information. Our company is best assignment service provide in ireland. Student can choose the multiple subject and multiple topic. Our When itcomes to writing assignments is most important to make a proper planning of all the steps so that the assignment can be completed timely and perfectly. Before starting writing students should plan the structure of the assignment and decide how much time they should give to any segment of the assignment. A goodstructure of Assignment Help you to maintain the proper flow of the researched information.

    ReplyDelete
  6. Looking for Finance assignment help? Then, at that point, you are at the perfect location, we are one of the most mind-blowing finance task aides. The tasks concerning finance are specialized and need inside and out subject mastery commonly. That is the reason you want master proficient essayists for finishing your task.

    ReplyDelete
  7. GameCaster is the easiest and power-packed recording tool. Besides online streaming, you can easily record your gameplay at high quality. It comes with a variety of features that you can use to increase the quality of the gameplay such as picture-in-picture mode, video annotations, and social media integration. It also allows you to edit the video with an in-built video editor. This is why it is the game recording software for PC windows 7, 8.1, and 10.

    ReplyDelete
  8. Nursing is a popular career choice for aspiring medical students who want to serve others and make a difference in their lives. Students must complete difficult Assignment helper by their university with Assignment help master a wide range of topics in order to become acknowledged nurses.

    ReplyDelete
  9. It is super easy to find homework doer on the web. However, it is not that easy to find genuine assignment help online. You really have to be cautious and careful while finding and shortlisting websites that offer help to students.

    ReplyDelete
  10. Fin indisk mad. Meget venlig betjening. Vi fik vores egen "buffet" på bordet med fire take away frederiksberg forskellige varme retter samt forretter. Ekstra plus: de har indisk vin ����

    ReplyDelete
  11. To get the best singapore homework help, you need to first submit your Singaporeassignmenthelp topic to us. Fill out the order form correctly, mention every minute details in it. If you have any additional demands,provide that too. Move on the two-second step.

    ReplyDelete
  12. College professors allocate assignments with a specific deadline and students need to submit the assignment on a certain time frame. Students feel it is better to take Assignment Help for submitting top-quality assignments at the scheduled time.

    ReplyDelete
  13. I will always let you and your words become part of my day because you never know how much you make my day happier and more complete. There are even times when I feel so down but I will feel better right after checking your blogs. You have made me feel so good about myself all the time and please know pay to write my assignment that I do appreciate everything that you have

    ReplyDelete

  14. Therefore, the Plus Printer is the most versatile platform die cut packaging which regenerates the best of the product packaging. plus printer is a 24/7 service for all clients worldwide. There are expert teams at a plus printer that provides the best of suggestions.

    ReplyDelete
  15. Meget venligt og opmærksom personale, som kom med gode anbefalinger til både take away frederiksberg mad og drikke. Vi giver hermed vores bedste anbefaling, og vi glæder os allerede til næste gang.
    for sure. At our business, we curate a combination of cutting-edge packaging presentation packaging tools and top-notch material, for the prime reason of staying competitive. The bottom line is that customboxesbulk guarantee quality at each step.

    ReplyDelete

  16. Complete Confidentiality The safety and integrity writemyessayplz of your data are of crucial importance to us. We don't want anyone snooping around, and neither do you, hence all your do my paper for me requests are confidential.

    ReplyDelete
  17. and there are quite a few reasons for that. The professionalism of our write my essays MA and Ph.D. writers, combined with a 100% originality guarantee, absolute anonymity, and a pocket-friendly price, is what makes us the best.Order your papers from pros now, and we’ll bring you on the fast track to success!

    ReplyDelete
  18. Informative post on Insert a chart from an Excel spreadsheet into Word.Thanks for sharing this.Get professional translation service singapore from Singapore translators. We have a dedicated team of language experts who are capable to provide the best translation/advice for PR translation into desired language.

    ReplyDelete
  19. Great food and good service. bedste take away københavn Taste of India and lots to choose from
    we offer quick and affordable shipping, and we value each one of our wholesale shorts customers. With a huge variety of reputable brands and bulk t-shirts to choose from with quality that is second to none, we’re thrilled to offer blank apparel and unbeatable customer service that will not disappoint!

    ReplyDelete

  20. Maden var intet mindre end fantastisk! 3 vegetar-hovedretter, ialt 8. take away albertslund Dertil salatbar og mange dressinger/dips/chutneys. Naan og ris.
    Have ordered lots of items and I am always impressed 65 polyester t shirts wholesale with the quality, speed of order processing and excellent customer service. Keep up the good work!

    ReplyDelete
  21. I'm looking for where I can buy presentation online because I need to present a PowerPoint presentation that represents useful aspects of using Microsoft Office at the workplace for teachers. I will be glad to find some tips where I can find them?

    ReplyDelete
  22. Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Zonahobisaya
    Dobra strona internetowa : Resep

    ReplyDelete
  23. This post is really very well with knowledgably content. Finally I searched Top 10 VPN on google for making my online privacy secure from the outer attacks. Seriously VPN is worth able for online security.

    ReplyDelete
  24. Microsoft Office Tutorials: Insert A Chart From An Excel Spreadsheet Into Word >>>>> Download Now

    >>>>> Download Full

    Microsoft Office Tutorials: Insert A Chart From An Excel Spreadsheet Into Word >>>>> Download LINK

    >>>>> Download Now

    Microsoft Office Tutorials: Insert A Chart From An Excel Spreadsheet Into Word >>>>> Download Full

    >>>>> Download LINK oV

    ReplyDelete
  25. Microsoft Office Tutorials: Insert A Chart From An Excel Spreadsheet Into Word >>>>> Download Now

    >>>>> Download Full

    Microsoft Office Tutorials: Insert A Chart From An Excel Spreadsheet Into Word >>>>> Download LINK

    >>>>> Download Now

    Microsoft Office Tutorials: Insert A Chart From An Excel Spreadsheet Into Word >>>>> Download Full

    >>>>> Download LINK L1

    ReplyDelete
  26. I trully appretiate your work and tips given by you is helpful to me. I will share this information with my family & friends. This is a great website, keep the positive reviews coming. This is a great inspiring .I am pretty much pleased with your good work.assignment writing help You put really very helpful information. I am looking to reading your next post. !!!!

    ReplyDelete
  27. It is good to hear that your store is now expanding to new locations. I have been a patron of Fantastic Eyes because of all the wonderful work that you guys do.pay to write my dissertation I hope that this expansion move of yours will turn out to be successful. I will definitely go and see this new store of yours

    ReplyDelete
  28. It was a very good post indeed. I thoroughly enjoyed reading it in my lunch time. Will surely come and visit this blog more often. Thanks for sharing. There are so many fun and help with assignment exciting things to do and experiences around the world that I thought I ‘d put together a list of favorite things to do for all travelers.

    ReplyDelete
  29. This piece of writing is really a pleasant one it helps new web viewers who are wishing in favor of blogging. I had a nice time coming access through this blog article. Thank you for sharing. Also visit edwin clark university school fee schedule for all students

    ReplyDelete
  30. Diana Rosell is an academician helping students overcome major assignment-related problems. She is associated with the Homework HelpMyAssignmenthelp.com. She is also an independent blogger and writes about various things related to modern education and business.
    Services Nearby :
    Assignment Help Dubai
    Assignment Help Sharjah

    Some Free Assessment For Your Reference:
    Theoretical Ideas and Concepts
    media in contemporary society

    ReplyDelete
  31. The name microbiology itself suggests the intricacies that it carries in the syllabus. Students often feel helpless in front of these complex subjects when they are asked to write assignment papers keeping the subjects in view. When they are underprepared they fail to write good paper solutions. To score well grades it buses essentially that you write immaculate and high-quality content with valid information. Microbiology assignment help is here to help you with the best paper solutions that bring good grades with the utmost guarantee. Hence worry not about your paper queries just drop them to our subject matter experts. You get the finished answers that students can deliver to the professors directly.

    ReplyDelete
  32. In case a pharmacy school personal statement seems to be complicated to write for you - don't lose your time and get professional writing help on the above-mentioned website. I very often use it as my writing skills need some improving.

    ReplyDelete
  33. I truly fancy your blog post plus your creative excel spreadsheet education. I am really impressed to read alot of useful inspiring articles. You are such a fantastic weblog. Keep it up! Thank youso much for sharing. college of nursing science emekuku forms visit - Best Related Educational Updates Portal in the World; Examination and Academic Guide, High Paying Jobs & Scholarship Website

    ReplyDelete
  34. Address: Level 5,121 Castlereagh Street Sydney, NSW 2000
    Whatsapp No: +61 280062221
    Email id: info@thetutorshelp.com

    https://www.thetutorshelp.com/business-management-assignment-help.php
    Business management assignment help

    ReplyDelete
  35. Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this. I also wanna talk about the best oil lubricants.

    ReplyDelete