23. Charts

23. Charts

23.1. Introduction

A chart is a instrument you need to use to speak knowledge graphically. Together with a chart in a presentation permits your viewers to see the which means behind the numbers, which makes it straightforward to visualise comparisons and developments.

Kinds of charts

PowerPoint has a number of kinds of charts, permitting you to decide on the one that most closely fits your knowledge. In an effort to use charts successfully, you may want to know how completely different charts are used.

Concerning the kinds of charts in PowerPoint.








Figuring out the elements of a chart

Along with chart sorts, you may want to know the right way to learn a chart. Charts include a number of completely different parts—or elements—that may enable you interpret knowledge.



The legend identifies which knowledge collection every coloration on the chart represents. On this instance, the legend identifies the completely different months within the chart.

23.2. Inserting charts

PowerPoint makes use of a spreadsheet as a placeholder for getting into chart knowledge, very similar to Excel. The method of getting into knowledge is pretty easy, however if you’re unfamiliar with Excel you would possibly wish to evaluation our Excel 2016 Cell Fundamentals lesson.

To insert a chart:
1) Choose the Insert tab, then click on the Chart command within the Illustrationsgroup.

2) A dialog field will seem. Choose a class from the left pane, and evaluation the charts that seem in the precise pane.
3) Choose the specified chart, then click on OK.

4) A chart and a spreadsheet will seem. The information that seems within the spreadsheet is placeholder supply knowledge you’ll exchange with your individual data. The supply knowledge is used to create the chart.


5) Enter knowledge into the worksheet.


6) Solely the information enclosed by the blue traces will seem within the chart, however this space will develop mechanically as you proceed to sort.


7) While you’re executed, click on X to shut the spreadsheet.


8) The chart might be accomplished.


* You’ll be able to edit the chart knowledge at any time by deciding on your chart and clicking the Edit Information command on the Design tab.


* You may as well click on the Insert Chart command in a placeholder to insert a brand new chart.


Creating charts with current Excel knowledge

If you have already got knowledge in an current Excel file you wish to use for a chart, you’ll be able to switch the information by copying and pasting it. Simply open the spreadsheet in Excel, choose and replica the specified knowledge, and paste it into the supply knowledge space on your chart.

You may as well embed an current Excel chart into your PowerPoint presentation. This can be helpful when you may have to replace the information in your Excel file and wish the chart to mechanically replace at any time when the Excel knowledge is modified.

23.3. Modifying charts with chart instruments

There are various different methods to customise and arrange your charts. For instance, PowerPoint permits you to change the chart sort, rearrange a chart’s knowledge, and even change the format and elegance of a chart.

To vary the chart sort:

When you discover that your knowledge is not effectively suited to a sure chart, it is easy to modify to a brand new chart sort. In our instance, we’ll change our chart from a column chart to a linechart.

1) Choose the chart you wish to change. The Design tab will seem on the precise aspect of the Ribbon.


2) From the Design tab, click on the Change Chart Kind command.


3) A dialog field will seem. Choose the specified chart sort, then click on OK.


4) The brand new chart sort will seem.


To modify row and column knowledge:

Generally it’s possible you’ll wish to change the best way charts group your knowledge. For instance, within the chart beneath the guide gross sales knowledge is grouped by style, with traces for every month. Nevertheless, we might swap the rows and columns so the chart will group the information by month, with traces for every style. In each circumstances, the chart comprises the identical knowledge; it is simply organized in a different way.

1) Choose the chart you wish to modify. The Design tab will seem.
2) From the Design tab, choose the Edit Information command within the Information group.


3) Click on the chart once more, then choose the Change Row/Column command within the Information group.


4) The rows and columns might be switched. In our instance, the information is now grouped by month, with traces for every style.


!!! We have observed that when numerical knowledge has been entered within the first column of the spreadsheet, switching rows and columns might trigger surprising outcomes. One resolution is to sort an apostrophe earlier than every quantity, which tells the spreadsheet to format it as textual content as an alternative of a numerical worth. For instance, the 12 months 2016 can be entered as ‘2016.

To vary the chart format:

Predefined chart layouts mean you can modify chart parts—together with chart titles, legends, and knowledge labels—to make your chart simpler to learn.

1) Choose the chart you wish to modify. The Design tab will seem.
2) From the Design tab, click on the Fast Format command.


3) Choose the specified predefined format from the menu that seems.

4) The chart will replace to mirror the brand new format.


* To vary a chart component (such because the chart title), click on the component and start typing.


To vary the chart type:

Chart types mean you can shortly modify the feel and appear of your chart.

1) Choose the chart you wish to modify. The Design tab will seem.
2) From the Design tab, click on the Extra drop-down arrow within the Chart Stylesgroup.


3) Choose the specified type from the menu that seems.


4) The chart will seem within the chosen type.


* You may as well use the chart formatting shortcut buttons to shortly add chart parts, change the chart type, and filter the chart knowledge.

Updated: February 28, 2019 — 3:16 am

Leave a Reply