How to create a PowerPoint Chart with Chartrics Excel Add-in

 

If you are engaged in Excel tasks and require the creation of a visually appealing report, it is likely that you will need to transform your Excel data into charts for PowerPoint. The most common practice is to create charts in Excel and copy-paste them into PowerPoint slides one by one. Moreover, if you need to link the data back to an Excel sheet, you have to use the corresponding paste option enabling updates to the PowerPoint data whenever the source Excel file is modified.

Chartrics Excel add-in provides you with a totally new method to link your calculated tables from Excel to PowerPoint charts. You don't have to create charts in Excel then copy-paste them to PowerPoint slides. Instead, just select a cell or table range and save them to the Chartrics table library (Cloud). Once you have all the tables selected and saved in the Cloud, you can easily connect them to PowerPoint charts with the help of a drag-and-drop Chart Maker integrated into PowerPoint.

By using the Chartrics, you can establish a secure link between your PowerPoint charts and the Excel file, enabling you to refresh the charts whenever the data in the source file is updated.

 

Method

  1. Open the Excel file either from the Chartrics Cloud or save the local Excel file into the Cloud.*
  2. Click on the Quick Add button to select a specific cell or range in Excel
  3. Assign a name to the selected cell or table and save it.
  4. Open PowerPoint and insert a chart by clicking on the Chart Maker option
  5. From the top left corner of the chart making canvas, go to the Workbook tab and select the Excel you were working on
  6. Drag and drop the tables into the chart making area and then click Apply

 

* If you don’t see Chartrics add-in in Excel toolbar, follow these steps

  • From File select Options then, click on Add-Ins button 
  • From Manage section choose Com add-ins
  • In opened window select “Chartrics Excel Add-in”

 

Automatically update all your PowerPoint charts with the new data in 15 seconds.