chapter 3 excel chartselearning.algonquincollege.com/coursemat/haugs/2_f_15_bus2305/… · •in...
TRANSCRIPT
![Page 1: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/1.jpg)
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. 1
by Mary Anne Poatsy, Keith Mulbery, Lynn Hogan, Amy Rutledge, Cyndi Krebs, Eric Cameron, Rebecca Lawson
Chapter 3
Excel Charts
![Page 2: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/2.jpg)
• Select the data source
• Choose a chart type
• Move, size, and print a chart
• Add chart elements
2Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 3: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/3.jpg)
• Format chart elements
• Apply a chart style and colors
• Modify the data source
• Create and customize sparklines
3Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 4: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/4.jpg)
• A chart is a visual representation of numeric
data
4
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 5: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/5.jpg)
• Chart elements include:
– Chart Area
– Plot Area
– X-Axis
– Y-Axis
– Category Axis
– Value Axis
– Legend
5
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 6: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/6.jpg)
6Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 7: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/7.jpg)
• Select the data
• Click the Quick
Analysis button
• Click the
thumbnail of
the chart you
want
7Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 8: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/8.jpg)
• A column chart displays data vertically, with
each data series forming a column
8Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 9: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/9.jpg)
9Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 10: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/10.jpg)
10Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 11: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/11.jpg)
11Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 12: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/12.jpg)
12Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 13: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/13.jpg)
13Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 14: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/14.jpg)
14Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 15: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/15.jpg)
15Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 16: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/16.jpg)
• Using the Chart Tools contextual tab:
– Click the DESIGN tab
– Click Change Chart Type
– Click ALL CHARTS
– Select the desired chart type
16Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 17: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/17.jpg)
17Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 18: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/18.jpg)
• To move a chart:
– Click the DESIGN tab
– Click Move Chart under the Location group
18Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 19: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/19.jpg)
• To print an embedded chart:
– Select the chart
– Click the FILE tab
– Click Print to display settings
– Use the Print Selected Chart option
19Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 20: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/20.jpg)
• A chart element is a component that helps
clarify the chart.
20Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 21: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/21.jpg)
21Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 22: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/22.jpg)
• 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
22Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 23: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/23.jpg)
• To display a chart
element’s task
pane, double-click
the chart element.
23Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 24: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/24.jpg)
• Excel computes
starting, ending,
and incremental
values for display
on the value axis
24Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 25: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/25.jpg)
25Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
• A data label is the value
or name of a data point
![Page 26: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/26.jpg)
26Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 27: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/27.jpg)
• A chart filter controls which data series and
categories are visible in a chart
27Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 28: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/28.jpg)
• A sparkline is a miniature chart displayed in a
single cell
28Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 29: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/29.jpg)
• In this chapter, you have learned to create charts
such as column, bar, pie, and line charts by
selecting the data source.
• You can modify an existing chart by changing
the chart type, location, size, as well as how to
print the chart.
• You can insert, remove, and format chart
elements such as titles, labels, and the legend.
29Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 30: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/30.jpg)
• You can apply different chart styles and colors
to format a chart.
• You can modify the data source including
adding or removing data and creating chart
filters and switching rows and columns.
• You can now create and customize sparklines.
30Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
![Page 31: Chapter 3 Excel Chartselearning.algonquincollege.com/coursemat/haugs/2_F_15_BUS2305/… · •In this chapter, you have learned to create charts such as column, bar, pie, and line](https://reader033.vdocuments.us/reader033/viewer/2022051810/60174601c89f0c6a0937b8c1/html5/thumbnails/31.jpg)
31Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.