Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
Select the right chart for your data, add it to a slide, know the basics of editing charts and quickly format charts.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the ‘before’ and ‘after’ PowerPoint presentations from the video tutorial and try the lesson yourself.Adding and Editing Charts.pptx
119.3 KB Adding and Editing Charts - Complete.pptx
Working with charts in PowerPoint.
When to use
To explain complex topics using data-rich charts.
To insert charts on our slide
- On the Insert tab, in the Illustrations group, click Chart.
- Click the Insert Chart icon within a placeholder.
- Column – when there is a relationship between the categories.
- Line – good for time-series that are continuous, e.g. temperature or stock market fluctuations.
- Pie: add up to 100% – comparison is important, not so much the numbers themselves. You can only use these when you have a single series or category of data.
- Bar – when there is no direct relationship between the categories.
- Area – where the sum of plotted values is important to compare.
- X Y (Scatter) – values on 2 axes, e.g. humidity at a set temperature.
- Enter data directly or paste in.
- Press the Tab key or Enter key to move the active cell.
- Can manually add formulae.
- New row: right-click header, Insert – becomes a new category.
- New column: right-click the header – becomes a new series.
- Or drag the boundary handles.
- Switch row / column becomes unavailable – datasheet is closed down.
- Chart Layouts and Chart Styles quickly format a chart with a predetermined style.
- Various chart elements can be formatted such as an entire series or an individual element within a series from options on the Format tab on the ribbon.
Working with the data sheet
Three-dimensional charts are only appropriate when you have three data variables (X, Y, Z) to display.Login to download
Lesson notes are only available for subscribers.