How to Create a PowerPoint Chart with Raw Data

When survey data is collected, the next step is analyzing and transforming it into meaningful charts so the patterns can be easily understood. To create charts with the raw data, researchers have to go beyond Microsoft PowerPoint and use other tools with the respective capabilities. Usually, creating charts from raw data requires either creating pivot tables in Excel or using BI tools with the opportunity to easily cross the variables. In both cases, you will have to copy the charts and paste them into PowerPoint slides one by one, which is time-consuming and creates some limitations in terms of flexibility.

To increase efficiency and save time on switching between the tools, Chartrics provides an easy-to-use chart-making tool integrated into PowerPoint.  It is designed to create PowerPoint charts from raw data by just dragging and dropping the variables into a special chart-making canvas. Once the variables are crossed, and some data shaping is done, you just need to click OK to visualize the result right on PowerPoint slides.

Follow the steps below to create a simple chart in your PowerPoint presentation with the raw data stored in Chartrics Cloud:

Required Condition*
  • Dataset uploaded into the Chartrics Cloud in SPSS, CSV, or Excel formats.
  • A PowerPoint presentation saved and opened from the same project folder as the dataset.

Method

  1. In PowerPoint go to the Chartrics tab
  2. Insert a chart > right-click on it > select Chart Maker
  3. From the top-left corner of the Chart Maker canvas, select or upload a dataset
  4. Drag a variable and drop it onto the Row or Column shelf > Apply

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