link Table and Chart from Excel to PowerPoint

By Fares Solution, 14 December, 2023

Here's a step-by-step guide on how to link a table and chart from Excel to PowerPoint:

Linking Table from Excel to PowerPoint:

  1. Open Excel: Open the Excel file containing the table you want to link.

  2. Highlight the Table: Select the entire table or the specific range of cells you want to link.

  3. Copy the Table: Right-click on the highlighted area, choose "Copy" from the context menu, or use the keyboard shortcut (Ctrl+C).

  4. Open PowerPoint: Open the PowerPoint presentation where you want to link the Excel table.

  5. Navigate to the Slide: Go to the slide where you want to place the Excel table.

  6. Paste in PowerPoint: Right-click on the desired location on the slide, and choose "Paste" from the context menu or use the keyboard shortcut (Ctrl+V).

  7. Paste Special (Optional): If you want to customize the paste options, such as linking or embedding, choose "Paste Special" from the context menu and select the desired option.

  8. Paste Link: Choose "Paste Link" to establish a dynamic link between the Excel table and the PowerPoint slide.

  9. Select Microsoft Excel: From the Paste Link options, choose "Microsoft Excel" to ensure a live connection.

  10. Click OK: Confirm the paste link by clicking "OK."

  11. Adjust Formatting (Optional): Format the table in PowerPoint as needed to match your presentation style.

Linking Chart from Excel to PowerPoint:

  1. Create a Chart in Excel: In Excel, create the chart you want to link to PowerPoint.

  2. Copy the Chart: Right-click on the chart, select "Copy" from the context menu, or use the keyboard shortcut (Ctrl+C).

  3. Open PowerPoint: Open the PowerPoint presentation where you want to link the Excel chart.

  4. Navigate to the Slide: Go to the slide where you want to place the Excel chart.

  5. Paste in PowerPoint: Right-click on the desired location on the slide, choose "Paste" from the context menu, or use the keyboard shortcut (Ctrl+V).

  6. Paste Special (Optional): If needed, use "Paste Special" to customize the paste options, choosing between linking or embedding.

  7. Paste Link: Choose "Paste Link" to establish a dynamic link between the Excel chart and the PowerPoint slide.

  8. Select Microsoft Excel: From the Paste Link options, choose "Microsoft Excel."

  9. Click OK: Confirm the paste link by clicking "OK."

  10. Adjust Formatting (Optional): Format the chart in PowerPoint to suit your presentation style.

By following these steps, you'll create a dynamic link between your Excel table/chart and PowerPoint, ensuring that any changes made in Excel will automatically reflect in your PowerPoint presentation.