Excel Chart in PowerPoint

Learning Objectives

  • Create PowerPoint slide with integrated Excel chart.

Option 1 for Chart Integration

The next slide in the presentation is the budget distribution chart. Cameron will create a chart from scratch in a new slide. He opens the New Slide options and selects Content with Caption, then types in the title in the box. He moves the cursor over the large box and clicks on the Insert Chart icon and decides on the type of chart.

A Microsoft Powerpoint for a sales campaign is displayed. A green arrow is pointing at where to insert a new chart.

A Microsoft Powerpoint for a sales campaign is displayed. The powerpoint is open the the fifth slide.

For this slide, he selects a 3-D Pie chart. A small Excel spreadsheet pops up above the pie chart for Cameron to enter the data for the chart.

A Microsoft Powerpoint for a sales campaign is displayed. A new insert chart box has been opened in front of the deck of slides.

A Microsoft Powerpoint for a sales campaign is displayed. An excel sheet has been opened and is now displayed in front of the slides.

Cameron begins to type in the data by double-clicking on a cell and replacing the text or numbers in it. He changes the numbers cells to percentages. There is an extra row he doesn’t need, so he selects it, right-clicks, and selects the Delete Row from the menu. Cameron now clicks the X in the small window and closes it.

A Microsoft Powerpoint for a sales campaign is displayed. An excel sheet has been opened and is now displayed in front of the slides. There are two green arrows, the first is pointing at a specific row in the excel sheet and the second is showing how to delete the row.

A Microsoft Powerpoint for a sales campaign is displayed. An excel sheet has been opened and is now displayed in front of the slides. A green arrow is pointing at the option to close from the excel sheet.

Cameron decides to show the budget present age on the chart and needs to modify a few other aspects about the chart to make it easier to see.

A Microsoft Powerpoint for a sales campaign is displayed. Four green numbers show different formatting options, the first shows where the chart elements button is. The second shows where the elements list is, the third shows where the arrow button is and the fourth where that data table list can be found.

He takes the following steps:

  1. Chart Elements Button. This + button allows Cameron to change aspects of the chart.
  2. Elements List. Cameron clicks the Data Labels box to change the labels.
  3. Arrow Button. Cameron clicks the small right arrow, and a new menu appears.
  4. Data Label List. Cameron moves the chart numbers to the center of their respective areas.

Next, Cameron changes the area numbers to percentages and increases the font size of the chart text and the Store label sizes.

 

A Microsoft Powerpoint for a sales campaign is displayed. In the chart that has been inserted previously, there are two green arrows showing that the font size in the chart is being adjusted from size 12 to size 18.

The chart is now too close to the store labels. Cameron clicks on the chart and hovers over the border until the four-arrow cursor appears. He drags the chart up, closer to the title. This centers the chart and makes it easier to read the labels.

A Microsoft Powerpoint for a sales campaign is displayed. In the chart on the slide it is displayed that it has been centered.

Option 2 for Chart Integration

What if Cameron had an existing sales budget chart? He could copy and paste the chart into his presentation. First he opens the Excel file with the chart in it. Since he has learned to copy and paste from the previous table, he puts the PowerPoint and Excel windows side by side then takes the following steps:

A Microsoft Powerpoint for a sales campaign is displayed with a microsoft excel sheet directly to its left. There are three green numbers, the first one shows that the excel sheet has been selected, the second shows that the chart has been selected and the third shows that the chart has been copied.

  1. Select Excel. Cameron makes sure Excel is the current window and opens the chart file.
  2. Select Chart. Cameron selects the chart in the Excel file by right-clicking on the chart.
  3. Select Copy. Cameron sees a menu appear and selects the Copy choice. He can also use Ctrl+C to copy the chart.

Practice Question

A Microsoft Powerpoint for a sales campaign is displayed with a microsoft excel sheet directly to its left. The excel sheet is now selected and shows that a chart is being pasted. The chart has also been resized to fit the slide.

  1. PowerPoint Presentation Paste Chart. With the desired chart copied, Cameron moves over to his PowerPoint presentation and places the curser in the correct spot and right-clicks again to bring up the menu. In the menu he selects the Paste option and the chart is placed in the presentation. He can also use the Ctrl+V keys to paste the chart.
  2. Resize Chart. Cameron now grabs one of the chart border area spots and moves it to the desired size in the presentation.

A Microsoft Powerpoint for a sales campaign is displayed with a microsoft excel sheet directly to its left. The chart that has been pasted from the excel sheet now has been edited with several formatting options.

  1. Change Chart. If Cameron needs to change something about the chart, such as the type of chart, the data in the chart, the labels, and so on, he can right-click on the chart itself. A menu will appear that allows him to change aspects of that chart. Any changes made will not affect the original Excel file chart.

Practice Question