How to Insert Charts in PowerPoint

Introduction

In the realm of professional communication, a chart serves as a powerful bridge between abstract numerical data and audience comprehension. By translating numbers into graphical representations, you enable your audience to visualize complex comparisons, identify underlying trends, and grasp the significant "story" hidden within the data. Have you ever wondered why a simple line can be more persuasive than a thousand-row spreadsheet?

Types of charts

Selecting the appropriate chart type is a strategic decision. To communicate effectively, one must choose a visualization that aligns with the specific narrative of the data. Use the interactive slideshow below to explore the diverse chart architectures available in PowerPoint and consider: which of these would best represent your current project?

❮ ❯

Types of charts

PowerPoint offers a sophisticated array of chart types, each engineered for specific analytical advantages. Explore the subsequent slides to identify their unique applications.

Column Charts

Utilizing vertical bars, Column charts are exceptionally effective for side-by-side comparisons across various categories.

Line Charts

Ideally suited for longitudinal data, Line charts connect individual data points to reveal whether values are appreciating or depreciating over time.

Pie Charts

Pie charts illustrate proportional relationships. Each "slice" represents a component percentage of a unified whole.

Bar Charts

Operating similarly to Column charts, Bar charts utilize horizontal bars, often preferred when category labels are lengthy.

Area Charts

Similar to line charts, Area charts fill the space beneath the lines to emphasize the magnitude of change over time.

Surface Charts

For extensive data sets, Surface charts provide a 3D landscape view, allowing for the simultaneous analysis of multiple variables.

Identifying the parts of a chart

To interpret data accurately, one must understand the anatomy of a chart. Each element, from the axes to the legend, plays a critical role in providing context. Click the interactive points below to master the terminology of chart construction.

+

Chart Title

The title should clearly describe the data being presented.

+

Vertical Axis (Y-Axis)

The vertical scale used to measure the data points.

+

Horizontal Axis (X-Axis)

The category scale where data is organized.

+

Data Series

The data series consists of the related data points in a chart. In this example, as we can see in the legend, the yellow columns represent net sales in February.

+

Legend

The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart.

Inserting charts

PowerPoint utilizes an integrated spreadsheet interface—sharing the same DNA as Microsoft Excel—to act as the engine for your data. This interoperability ensures that your graphical output is always precise and grounded in raw data.

To insert a chart:

1. Select the Insert tab, then click the Chart command in the Illustrations group.

2. A dialog box will appear. Select a category from the left pane, and review the charts that appear in the right pane.
3. Select the desired chart, then click OK.

4. A chart and spreadsheet will appear. The data that appears in the spreadsheet is placeholder source data you will replace with your own information. The source data is used to create the chart.

5. Enter data into the worksheet.

6. Only the data enclosed by the blue lines will appear in the chart, but this area will expand automatically as you continue to type.

7. When you're done, click X to close the spreadsheet.

8. The chart will be completed.

Creating charts with existing Excel data

If you have already performed extensive analysis in Microsoft Excel, there is no need to re-enter your data. You can simply copy the desired range from Excel and paste it into the PowerPoint chart spreadsheet. For those requiring a live connection, consider embedding the chart; this ensures that as your Excel file evolves, your PowerPoint presentation reflects those changes automatically.

Modifying charts with chart tools

The initial creation of a chart is merely the first step. To truly engage your audience, you must refine the narrative through customization—from structural changes to aesthetic polishing.

To change the chart type:

Should you determine that your current visualization is not effectively communicating the data, you can pivot to a different format without re-entering any information.

1. Select the chart you want to change. The Design tab will appear on the right side of the Ribbon.

2. From the Design tab, click the Change Chart Type command.

3. A dialog box will appear. Select the desired chart type, then click OK.

To switch row and column data:

Often, the "story" of the data changes based on how it is grouped. By switching the rows and columns, you can shift the focus of your analysis (e.g., viewing profits by Genre versus viewing profits by Month).

1. With the chart selected, click Edit Data.
2. Re-select the chart and click Switch Row/Column in the Data group.

To change the chart layout:

Predefined layouts offer a professional shortcut to organizing titles, legends, and labels. Navigate to the Quick Layout command on the Design tab to explore these structured options.

To change the chart style:

Finalize the visual impact of your data by exploring the Chart Styles gallery. These presets allow you to adjust the color palette and lighting effects to ensure your data is both readable and visually compelling.

Chart Challenge

Apply these sophisticated tools to a real-world scenario. Can you transform raw spreadsheet numbers into a compelling visual story?

1. Open our practice presentation and practice workbook.
2. Insert a Line chart on the final slide.
3. Copy the data from the Excel workbook and paste it into the PowerPoint chart spreadsheet.
4. Remove the Chart Title and change the type to a Stacked Column chart.
5. Apply Layout 10 from the Quick Layout menu.
6. Enable the Primary Vertical axis title via the Chart Elements shortcut and rename it Sale Profits.
7. Execute a Switch Row/Column command to reorient the data perspective.