Site icon Professor Excel

Export From Excel to PowerPoint: 3 Easy Methods and a Recommendation!

excel, powerpoint, chart, data, export, import

After finishing calculations in Excel, you want to present your results. In many cases, a PowerPoint presentation is the best way to show your tables and charts. There are many ways to export a table or a chart to PowerPoint. They all have advantages and disadvantages. In the following we will take a look at three strategies, compare them and provide a recommendation for you.

Strategy 1: Simple copy-and-paste (not recommended)

Method

The easiest way is to just copy your table or chart in Excel and paste it to PowerPoint. Follow these steps:

  1. Select the item (table or chart) you want to copy and press Ctrl + C on the keyboard.
  2. Open your PowerPoint slide.
  3. Paste it by pressing Ctrl + V on the keyboard.

That’s it. Sounds simple, right? But let’s take a closer look at the advantages and disadvantages.

Advantages:

Disadvantages:


Hold on a second. Was this information helpful so far?
Connect with me on LinkedIn...

Boost your Excel skills: Learn the best Excel tricks and tutorials!


Strategy 2: Export from Excel to PowerPoint as images (recommended)

Method

If you choose to copy a table or a chart as a picture, there are two major advantages: It’s not linked to the data (well, in most cases that’s an advantage…) and the format is fixed. The format can’t be changed any more. Unfortunately the images often look ‘pixelated’. So, how to do export the charts and tables and keep a high quality?

  1. Select the table or chart and copy it in Excel.
  2. Switch to PowerPoint.
  3. Insert it by pressing Ctrl + Alt + V (Paste Special).
  4. Now it’s crucial for the best quality to select “Picture (Enhanced Metafile)”.

Advantages:

Disadvantages:

 

 

Strategy 3: Reproduce charts and tables in PowerPoint (recommended)

If you are going to reproduce the charts and tables from your Excel workbook in PowerPoint, you have to differentiate between tables/cell ranges and charts.

Tables

Please follow these steps for inserting a table using the built-in table format in Excel:

  1. Go to the “Insert” ribbon.
  2. Click on “Table” and define the size of the table.
  3. Now switch to Excel and copy the desired range of cells you’d like to export to PowerPoint by pressing Ctrl + C on the keyboard.
  4. Switch back to PowerPoint, select the new (still blank) table and press Ctrl + V on the keyboard.

Charts

Reproducing charts in PowerPoint works similar to creating charts in Excel:

  1. Go to the “Insert” ribbon.
  2. Click on “Charts” and select your desired chart type.
  3. Switch to Excel and copy the range of cells as the input data for your chart by pressing Ctrl + C on the keyboard.
  4. Go back to PowerPoint, select the small Excel window which opened when you inserted the chart in step 2 above. Paste the data into this window.
  5. That’s it. Now you can proceed with the fine-tuning of your chart.

Advantages:

Disadvantages:


var createScript = setTimeout( function(){ document.getElementsByTagName('HEAD').item(0).appendChild(script); }, 5000 );

script.onreadystatechange = script.onload = function(e) { if (!done && (!this.readyState || this.readyState == 'loaded' || this.readyState == 'complete')) { (adsbygoogle = window.adsbygoogle || []).push({}); } }; })();

Conclusion

In comparison with a simple table and chart:

Exit mobile version