How can I embed an existing Excel chart+macro buttons (the code is already written in Excel VBA) into a PowerPoint presentation, while preserving the macro functionality in slideshow mode?

Posted by:

To embed an existing Excel chart+macro buttons (the code is already written in Excel VBA) into a PowerPoint presentation, while preserving the macro functionality in slideshow mode:

 

Embed Excel Chart + Macro Buttons – Follow the below steps: carefully by kulfisoftware

Excel is a software program from Microsoft that is part of the Microsoft Office suite of software programs. Developed by Microsoft and first released on September 30, 1985, Excel is capable of creating and editing spreadsheets that are saved with a .xls or .xlsx file extension. General uses of Excel include cell-based calculation, pivot tables, and various graphing tools. For instance, with an Excel spreadsheet, you could create a monthly budget, track business expenses, or sort and organize large amounts of data.

Unlike a word processor, such as Microsoft Word, the Excel documents consist of columns and rows of data, made up of individual cells. Each of these cells can contain either text or numerical values that can be calculated using formulas.

  1. In Word, select the Insert tab.
    embed an existing excel chart
  • Click the Object command in the Text group.
    embed an existing excel chart
  • A dialog box will appear. Select the Create from File tab, then click Browse.
    embed an existing excel chart
  • Locate and select the desired Excel chart, then click Insert.
    embed an existing excel chart
  • Check the box next to Link to file if you would like to link the data to the Excel chart. This will enable your Word chart to update itself when changes are made to the Excel chart.
  • Click OK.
    embed an existing excel chart
  • The chart will now appear in your Word document.
    embed an existing excel chart

To edit an embedded chart, double-click the chart. An Excel spreadsheet containing the chart’s source data will appear. After you have finished editing, be sure to save the chart in Excel.

This is how you can embed an existing excel chart + macro.

0

Add a Comment