Excel Chart in Word Document

Learning Outcomes

  • Create a Word document with integrated Excel chart.

There are a couple of ways to integrate an Excel chart into a Word document.

Option 1 for Chart Integration

The next piece of information needed in the report is the annual sales chart. To enter this data, Rosamine makes sure her cursor is at the place in the report she wants the chart to go. She clicks back to the Insert tab and selects the Chart button.

A word document is open with a sales report displayed. A green box is highlighting the insert tab on the ribbon menu. A green arrow is pointing at the option to add a chart and a second green arrow is pointing at a blank space on the word document

The next step is to select the type of chart to use for her report. In this instance, Rosamine chooses a line chart.

A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. A green arrow points at a new insert chart pop up menu. A second green arrow is pointing at the option to insert a line chart and a third arrow is pointing at the ok button.

  1. Chart Button/Line Chart. Rosamine selects the chart button and then selects a Line chart to use in her report.
  2. Chart Options. There are seven different variations for displaying a Line chart. Rosamine selects the first option.
  3. OK Button. With the desired chart selected, Rosamine clicks the OK button and the chart is placed in her report.

Next, Rosamine selects the style of line chart to use and begins to enter information to create the chart itself.

A Microsoft Word document is open with a sales report displayed. The navigation menu has been opened up to the left of the content. There are three green arrows, the first one is pointing at the chart styles, the second is pointing at a newly inserted chart, and the third is pointing at where to enter the data.

The chart will contain the total sales numbers from the last three years for each of the three retail stores. She puts the years in Column A (purple color), the name of the stores across row 1 (pink color), and the sales figures in the rest of the cells (blue color). Here is what her chart now looks like in the report.

A Microsoft Word document is open with a sales report displayed. A green arrow is pointing at the chart title of the newly inserted chart.

Rosamine clicks on the chart title box and changes the name of the chart to Annual Total Sales. Rosamine notices that the numbers are difficult to see, so she resizes the chart to make it easier to read.

Rosamine resizes the chart by clicking on the mid-points in the chart and dragging them to a larger size that still fits within the document column width.

A Microsoft Word document is open with a sales report displayed. There are two green arrows pointing at the bottom and left of the chart that has been inserted on the line chart. These two arrows point out how to resize the chart.

The General Manager will now see the rise and fall of sales over the last three years in Rosamine’s report.

To finish the report, Rosamine types in the rest of the text. Next she needs to link a PowerPoint presentation file for a reference mentioned in the report.

Option 2 for Chart Integration

What if Rosamine already had access to the Annual Total Sales chart file? She could copy and paste the chart into her document. First she opens the Excel file with the chart in it. Since she has learned to copy and paste from the previous table, she puts the Word and Excel windows side-by-side on her screen, then takes the following steps:

A Microsoft Word document is open with a sales report displayed. An excel sheet with data entered is open to the right of the word document. A green arrow is pointing at the excel sheet and at the option to copy to spreadsheet.

  1. Select chart. Rosamine selects the chart in the Excel file by clicking once on the chart.
  2. Right-click mouse. Rosamine clicks the right mouse button. She sees a menu appear and selects the Copy choice. She can also use the Ctrl+C keys to copy the chart.

A Microsoft Word document is open with a sales report displayed. An excel sheet with data entered is open to the right of the word document. A green arrow is pointing at the word document showing where to paste the recently copied excel sheet.

  1. Paste chart in Word document. With the desired chart copied, Rosamine moves over to her Word document and places the curser in the correct spot and right-clicks again to bring up the menu. In the menu she selects the Paste option and the chart is placed in the document. She can also use the Ctrl+V keys to paste the chart.
  2. Resize chart. Rosamine now grabs one of the chart border area spots and moves it to the desired size in the document.

A Microsoft Word document is open with a sales report displayed. An excel sheet with data entered is open to the right of the word document. Two green arrows are pointing at the bottom and left of the newly pasted excel chart in the word document, they are showing how to resize the chart.

  1. Change chart. If Rosamine needed to change something about the chart like the type of chart, the data in the chart, the labels, and so on, she can right-click on the chart itself, and a menu will appear that allows her to change aspects of that chart. Any changes made will not affect the original Excel file chart.

A Microsoft Word document is open with a sales report displayed. An excel sheet with data entered is open to the right of the word document. A green arrow points at a pop up window in the word document showing how you can change your chart.

If Rosamine wanted to use the copy and paste keyboard shortcut it would be exactly like the copy and paste from the table example and look like this:

A Microsoft Word document is open with a sales report displayed. An excel sheet with data entered is open to the right of the word document. Green text on the word document states ctrl+v and on the excel sheet green text states ctrl+c

To finish the report, Rosamine types in the rest of the text. Next, she needs to link a PowerPoint presentation file for a reference mentioned in the report.

Practice Questions