Transcript Excel Lesson 10

Excel Lesson 10
Using Advanced Chart Features
Microsoft Office 2010
Advanced
1
Cable / Morrison
Objectives

Excel Lesson 10

Switch rows and columns in charts.
Add a data table to a chart.
Add data labels to data markers.
Create sparklines.

2
Cable / Morrison

Microsoft Office 2010 Advanced
Objectives (continued)

Excel Lesson 10

Design combination charts.
Construct a gauge chart.
Create a chart template.
Apply a chart template.

3
Cable / Morrison

Microsoft Office 2010 Advanced
Vocabulary

Excel Lesson 10

chart floor
chart template
combination chart
data labels
data markers
data point

4
Cable / Morrison









data series
data table
gauge chart
horizontal gridlines
primary axis
secondary axis
Microsoft Office 2010 Advanced
Vocabulary (continued)

Excel Lesson 10

sparklines
vertical gridlines
x-axis
y-axis

5
Cable / Morrison

Microsoft Office 2010 Advanced
Introduction
Excel Lesson 10

6
Charts are a great solution for presenting
data in Excel graphically.
–
–

Simple to make and format
Can quickly change one type of chart to another
Excel has many chart formatting features.
Cable / Morrison
Microsoft Office 2010 Advanced
Understanding How Charts Are
Created

Charts are created from data in a worksheet.
Data is typically arranged in columns and rows
Excel Lesson 10
–
Worksheet with columns and rows of data
7
Cable / Morrison
Microsoft Office 2010 Advanced
Understanding How Charts Are
Created (continued)
Excel Lesson 10

The type of chart
determines how the
data in the rows and
columns will appear
in the chart.
Line chart created from worksheet data
8
Cable / Morrison
Microsoft Office 2010 Advanced
Switching Rows and Columns in
Charts
Excel Lesson 10

You can switch the
order of how chart
data is displayed in
a chart.
–
Use Switch
Row/Column button
on the Design tab
Chart with rows and columns switched
9
Cable / Morrison
Microsoft Office 2010 Advanced
Adding a Data Table
Excel Lesson 10

A data table displays the data used to create
a chart.
–
–

A legend is a list that shows the colors and
symbols used in a chart.
–
10
Appears below the chart
Lets you quickly view the worksheet data while
looking at the chart data series
Can appear as part of the data table or separately
Cable / Morrison
Microsoft Office 2010 Advanced
Adding a Data Table (continued)
Excel Lesson 10

11
Chart with
data table and
legend
Cable / Morrison
Microsoft Office 2010 Advanced
Adding Data Labels to Data Series
Excel Lesson 10

12


A data label can appear as numbers or text
next to each data marker in the data series.
The data markers represent where the
actual data would be in the chart.
Each place where the line segments start or
stop is a data point.
–
Can be displayed with a data marker
Cable / Morrison
Microsoft Office 2010 Advanced
Adding Data Labels to Data Series
(continued)
Completed chart
with data labels
Excel Lesson 10

13
Cable / Morrison
Microsoft Office 2010 Advanced
Creating Sparklines
A sparkline is a miniature chart that can be
displayed in a single row or column of data.
Excel Lesson 10

Types of sparklines
14
Cable / Morrison
Microsoft Office 2010 Advanced
Creating a Combination Chart
Excel Lesson 10

15
Combination chart: shows data on two yaxes
–
–
Primary axis: y-axis on the left side of chart
Secondary axis: y-axis on the right side of chart
Cable / Morrison
Microsoft Office 2010 Advanced
Creating a Combination Chart
(continued)
Combination chart
Excel Lesson 10

16
Cable / Morrison
Microsoft Office 2010 Advanced
Creating Gauge Charts
Excel Lesson 10

17



A gauge chart shows the amount of
progress accomplished toward a goal.
Horizontal gridlines are horizontal lines
within the chart.
Vertical gridlines are vertical lines within the
chart.
Chart floor is the foundation, or base, of a 3D chart.
Cable / Morrison
Microsoft Office 2010 Advanced
Creating Gauge Charts (continued)
Gauge chart
Excel Lesson 10

18
Cable / Morrison
Microsoft Office 2010 Advanced
Creating Chart Templates

To create a chart template:
Excel Lesson 10
–
19
–

Create and format a chart as desired
Save the chart as a template
Chart templates are saved in the same
default location as the preformatted chart
templates.
Cable / Morrison
Microsoft Office 2010 Advanced
Applying a Chart Template
Excel Lesson 10

20

After creating a chart template, you can apply
it to new charts that you create.
Applying a chart template to a chart will save
time.
–
Will not need to change each chart feature
individually
Cable / Morrison
Microsoft Office 2010 Advanced
Excel Lesson 10
Summary
21
In this lesson, you learned:
 You can switch rows and columns of data in
a chart.
 A data table that shows the data used to
create a chart can be added to the chart.
 Data labels can be added to data markers in
a data series.
Cable / Morrison
Microsoft Office 2010 Advanced
Summary (continued)
Excel Lesson 10

22


A sparkline is a miniature chart that can be
displayed in a single row or column of data.
You can design a combination chart that has
two y-axes.
You can construct gauge charts that show
progress towards a goal.
Cable / Morrison
Microsoft Office 2010 Advanced
Summary (continued)
Excel Lesson 10

23

A chart template can be created for a chart
design that will be used repeatedly.
Chart templates can be applied to charts
after they are created.
Cable / Morrison
Microsoft Office 2010 Advanced