Buzz
Enhance the persuasiveness of your PowerPoint presentation with accurate data from Excel. In this article, Mytour will guide you through the simplest way to insert Excel data into PowerPoint.
1. Link Excel Data to PowerPoint
To link an Excel table to a presentation slide, you need to prepare an Excel file with existing data. Once you have the initial data, follow the steps below.
Step 1: In Excel, mark the data you want to insert into PowerPoint. Right-click and choose Copy (or press Ctrl + C).
Step 2: Open your PowerPoint presentation. Navigate to the slide where you want to add the data.
Step 3: Ensure you're on the Home tab in the ribbon menu. Click the downward arrow button under Paste >> select Paste Special...
Step 4: Choose Paste link >> Microsoft Excel Worksheet Object >> OK.
Your spreadsheet data is now added to the slide, allowing you to freely adjust its position and size on the presentation page.
Since Paste link was chosen, the data on the slide will be linked to the Excel file. Any changes made in the Excel file will be continuously updated in PowerPoint. However, you cannot directly edit the data in PowerPoint; you'll need to open Excel to do so.
2. Insert a Line Chart into Excel
One of the easiest ways to visualize, compare, and analyze data is by using a line chart. If desired, you can also insert a line chart from Excel into PowerPoint.
Step 1: To create a line chart in Excel, you need to select your data, then choose Insert.
Step 2: Click on the Line Chart icon under the Charts section. Here, you can choose the type of chart you want to display, from 2D to 3D.
Step 3: Once the chart appears on the worksheet, right-click on it, select Copy (or press Ctrl + C).
Step 4: Open PowerPoint, navigate to the slide where you want to insert the chart.
Step 5: Click on the arrow icon below Paste. Here, you can choose Use Destination Theme & Link Data (L) + Keep Source Formatting & Link Data (F). The first option allows you to use the current theme for the presentation. Meanwhile, the second option retains the layout of the source Excel file.
Step 6: After pasting the chart into PowerPoint, you can move and resize it to fit the slide.
3. Update the Added Chart
There are several different ways for you to update the data or customize the chart that has been added to PowerPoint.
If you need to change the appearance of the map, simply double-click on it. When the Chart Design menu appears, choose a new layout in Chart Styles. Additionally, you can adjust design parameters in the window on the right-hand side.
When you want to edit the chart, you must open its original Excel file. Quickly do this by right-clicking on the chart >> selecting Edit Data >> Edit Data In Excel.
Usually, your changes in the Excel file will be automatically updated in PowerPoint. However, if you find that the changes are not reflected in the PowerPoint chart, you can update them manually.
To do this, double-click on your chart, when the Chart Design tab appears, select Refresh Data. This action will fetch the latest information from the linked Excel file.
Conclusion
Here are some simple tricks to help you add data from an Excel spreadsheet to a PowerPoint slide. Stay tuned to Mytour for more useful tips!
