How to Link Excel Data to PowerPoint Chart (3 Simple Methods)

In this tutorial, I am going to show you 3 simple methods on how to link excel data to a PowerPoint chart. You can use these methods mainly in large datasets to get any specific data that you want instead of manual copying. Throughout this tutorial, you will also learn some important excel tools and techniques which will be very useful in any excel related task.


Download Practice Workbook

You can download the practice workbook from here.


Why Do We Need to Link Excel to PowerPoint?

When we link our excel data to PowerPoint, it changes the data dynamically whenever we change the original excel file, saving us a lot of work. This is especially very helpful while working with large sets of data. Also, the procedures to create such a link is relatively easy. Otherwise copying and pasting the data manually would take a huge amount of time to complete.


3 Simple Methods to Link Excel Data to PowerPoint Chart

We have taken a concise dataset to explain the steps clearly. The dataset has approximately 7 rows and 2 columns. Initially, we are keeping all the cells in General format. For all the datasets, we have 2 unique columns which are Product and Sales(units). Although we may vary the number of columns later on if that is needed.

link excel data to powerpoint chart


1. Linking Entire Excel Worksheet to PowerPoint

In this first method, we will be looking at how to link the entire excel worksheet to a PowerPoint file. Follow the steps below to do this.

Steps:

  • First, select the data table.

linking entire worksheet to link excel data to a PowerPoint chart

  • Then, go to the Insert tab and click on Clustered Column under 2-D Column.

inserting chart to link excel data to a PowerPoint chart

  • As a result, this will generate a column chart from the dataset.

  • Next, open Microsoft PowerPoint and go to the Home tab at the top of the screen.
  • Now, click on the New Slide drop-down and select Blank.

  • Then, navigate to the Insert tab and click on Object under Text.

inserting object to link excel data to a PowerPoint chart

  • Next, in the Insert Object window, select Create from file and click on Browse.

  • Here, select the excel file that has the worksheet and click on OK.

selecting file to link excel data to a PowerPoint chart

  • After that, check the box Link and click on OK.

  • Immediately, this will create a link to your entire worksheet in the PowerPoint file as in the image below.

Read More: How to Select Data for a Chart in Excel (2 Ways)


Similar Readings


2. Using Paste Special to Link Data Section in Excel to PowerPoint

We can also link a specific data section in excel to PowerPoint using the Paste Special option. Below are the steps to achieve this.

Steps:

  • To begin with, this method, select the cells from B2 to C10 which has the dataset.
  • Next, navigate to the Home tab and select Copy.

use of paste special to link excel data to a PowerPoint chart

  • Now, open PowerPoint and go to the Home tab at the top of the screen.
  • Under this tab, select Paste and click on Paste Special.

  • Next, in the Paste Special window, select Paste link.
  • Then, select the worksheet object and click on OK.

  • Finally, this will link the excel dataset that you selected inside the PowerPoint file which will also change dynamically.

Read More: Selecting Data in Different Columns for an Excel Chart


3. Linking Excel Chart to PowerPoint

If you want to link only the chart section from excel to PowerPoint, then you can do that by following the steps below.

Steps:

  • To start with, select the chart in excel copy using Ctrl+C.

  • After that, open PowerPoint and go to the Home tab as before.
  • Now, under the Paste drop-down, click on Keep Source Formatting and Link Data.

  • Consequently, this will paste the chart with the link to the original excel file.

Read More: How to Change Data Source in Excel Chart (3 Useful Examples)


Things to Remember

  • Moving the excel file to another folder while PowerPoint is closed will break the link between them.
  • If you add a new row or column in the excel file, this may not update in the PowerPoint.
  • If you email the two files, the link may break for the recipient.
  • Linking in this way does not work for data within textboxes and shapes.

Conclusion

I hope that you were able to apply the methods that I showed in this tutorial on how to link excel data to a PowerPoint chart. As you can see, there are quite a few ways to achieve this. So wisely choose the method that suits your situation best. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.


Related Articles

Nazmul Hossain Shovon

Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo