Exploring Microsoft Office
Excel 2010
by Robert Grauer, Keith Mulbery,
and Mary Anne Poatsy
Chapter 3
Excel Charts
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 1
Objectives
• Decide which chart type to create
• Create a chart
• Change the chart type
• Change the data source and structure
• Apply a chart layout and style
• Move a chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 2
Objectives (continued)
• Print charts
• Insert and customize a sparkline
• Select and format chart elements
• Customize chart labels
• Format axes and gridlines
• Add a trendline
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 3
Chart Basics
• A chart is a visual representation of numeric
data
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 4
Chart Basics
• Chart components include:
– Data Points
– Data Series
– Category Labels
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 5
Column Charts
• A column chart displays data vertically, with
each data series forming a column
6
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall.
Clustered Column Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 7
Reversing Categories and Data
Series
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 8
Stacked Column Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 9
100% Stacked Column Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 10
3-D Column Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 11
Bar Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 12
Line Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 13
Pie Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 14
Area Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 15
X Y (Scatter) Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 16
Stock Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 17
Surface Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 18
Doughnut Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 19
Bubble Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 20
Radar Chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 21
Creating a Chart
• Select the data source
• Select the chart type
• Position and size the
chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 22
Changing the Chart Type
• Using the Chart Tools contextual tab:
– Click the Design tab
– Click Change Chart Type
– Select the desired chart type
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 23
Changing the Data Source
• To modify the chart data source:
– Click the Design tab
– Click Select Data under the Data group
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 24
Moving a Chart
• To move a chart:
– Click the Design tab
– Click Move Chart under the Location group
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 25
Printing a Chart
• To print an embedded chart:
– Select the chart
– Click the File tab
– Click Print to display the Backstage view
– Use the Print Selected Chart option
• To print a chart sheet:
– Use the Print Active Sheet option
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 26
Creating a Sparkline
• A sparkline is a miniature chart displayed in a
single cell
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 27
Chart Layout
• The Layout tab offers many ways to enhance a
chart visually
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 28
Selecting and Formatting Chart
Elements
• Formatting a chart
element:
– Right-click the element
and select the Format
element command
– The element portion will
change depending on the
selection (ex. Format
Data Series)
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 29
Customizing Chart Labels
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 30
Chart Titles and Legend
• A chart title is the label that describes the entire
chart
• An axis title is a label that describes either the
category or value axis
• A legend is used to distinguish data points in a
pie chart or data series in a multiple series chart
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 31
Data Labels
• A data label is the value or name of a data
point
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 32
Axes and Gridlines
• Excel computes starting, ending, and
incremental values for display on the value axis
• A gridline is a horizontal or vertical line
through the plot area
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 33
Adding a Trendline
• A trendline is a line used to depict trends and
forecast future data
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 34
Summary
• In this chapter, you have learned to create charts
such as column, bar, pie and line charts.
• You can modify an existing chart by changing
the chart type, location or data source.
• You can insert, remove, and format chart
elements such as titles, labels, and the legend.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 35
Questions
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 36
Copyright
All rights reserved. No part of this publication may be reproduced, stored in
a retrieval system, or transmitted, in any form or by any means, electronic,
mechanical, photocopying, recording, or otherwise, without the prior written
permission of the publisher. Printed in the United States of America.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall. 37
