Office
Excel 2010 by Robert Grauer, Keith
Mulbery, and Mary Anne
Poatsy
Chapter 3
Excel Charts
Copyright © 2013 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 © 2013 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 © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
3
Chart Basics
• A chart is a visual representation of numeric data
Copyright © 2013 Pearson Education, Inc. Publishing as
Prentice Hall.
4
Chart Basics
• Chart components include:
– Data Points
– Data Series
– Category Labels
Copyright © 2013 Pearson Education, Inc. Publishing as
Prentice Hall.
5
Column Charts
• A column chart displays data vertically, with each data series forming a column
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
6
Clustered Column Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
7
Reversing Categories and
Data Series
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
8
Stacked Column Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
9
100% Stacked Column
Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
10
3-D Column Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
11
Bar Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
12
Line Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
13
Pie Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
14
Area Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
15
X Y (Scatter) Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
16
Stock Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
17
Surface Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
18
Doughnut Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
19
Bubble Chart
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
20
Radar Chart
Copyright © 2013 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 © 2013 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 © 2013 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 © 2013 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 © 2013 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 © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
26
Creating a Sparkline
• A sparkline is a miniature chart displayed in a single cell
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
27
Chart Layout
• The Layout tab offers many ways to enhance a chart visually
Copyright © 2013 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 © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
29
Customizing Chart
Labels
Copyright © 2013 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 © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
31
Data Labels
• A data label is the value or name of a data point
Copyright © 2013 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 © 2013 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 © 2013 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 © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
35
Questions
Copyright © 2013 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 © 2013 Pearson Education, Inc. Publishing as Prentice
Hall.
37
You May Also Find These Documents Helpful
-
It’s the common ground and is used in all measurements. Black lead is placed in this connection.…
- 452 Words
- 4 Pages
Satisfactory Essays -
A conductor is made of materials that have little opposition to the flow of charge. A conductor is made of metals like copper, silver, aluminum or gold. These types of metals allows for the easy flow of electrons. Wires are made of these materials.…
- 302 Words
- 2 Pages
Satisfactory Essays -
Unshielded Twisted-Pair- A cable with multiple pairs of twisted insulated copper conductors bound in a single sheath.…
- 395 Words
- 2 Pages
Good Essays -
24. What is the difference between the logical design and the physical design of a database?…
- 292 Words
- 2 Pages
Satisfactory Essays -
Step 2: Explain what you think will be displayed to the screen in Step 1. (Reference: For…
- 365 Words
- 2 Pages
Satisfactory Essays -
4) Why is it important to match the latencies of the older modules to the newer modules?…
- 349 Words
- 2 Pages
Satisfactory Essays -
When a client connects to the MySQL server, the server uses the username provided by the client and the client host to select the appropriate account row from the mysql.user table. It then uses this row to authenticate the client. Before MySQL 5.5.7, the server authenticates the password provided by the client against the Password column of the account row. As of MySQL 5.5.7, the server authenticates clients using plugins. Selection of the proper account row from the mysql.user table is based on the user name and client host, as before, but the server authenticates the client credentials as follows: The server determines from the account row which authentication plugin applies for the client. If the account row specifies no plugin name, the server uses native authentication; that is, authentication against the password stored in the Password column of the account row. This is the same authentication method provided by MySQL servers older than 5.5.7, before pluggable authentication was implemented, but now is implemented using two plugins that are built in and cannot be disabled. If the account row specifies a plugin, the server invokes it to authenticate the user. If the server cannot find the plugin, an error occurs. The plugin returns a status to the server indicating whether the user is permitted to connect.…
- 287 Words
- 1 Page
Good Essays -
The COM connection is for the reference (ground) connection. The black lead is placed in this connection.…
- 410 Words
- 3 Pages
Satisfactory Essays -
As a new recruit working in a public service you have been asked to investigate the response to emergency service incidents.…
- 782 Words
- 4 Pages
Good Essays -
This week we are to pick two information technology acts to research and discuss the advances in information technology that resulted in new ethical issues that created the act. I currently work as a teller for a local bank and have chosen to research and discuss the Electronic Funds Transfer Act of 1978 and Fair Credit Reporting Act of 1970. I chose both of these because they coincide with my current job.…
- 603 Words
- 3 Pages
Satisfactory Essays -
Microsoft Access is a system that allows users to manipulate large amounts of data. The different areas and features of Microsoft provide quick learning and easy to use software which can benefit both small and large business environments. The different parts that make up Access are queries, reports, tables, modules and macros. Queries allow the user to pull information from the given tables and calculate using the information filled into the table. Tables associated with Access are used to store data. Information on the tables can be entered on the forms and printer-ready information is displayed on the report portion of Access, These reports can also be exported to Microsoft Excel or Word. The automation of database tasks are done using macros. Modules are used for advanced programming within the database. Microsoft Access is beneficial in the work environment because it incorporates features that are also found in other Microsoft Office applications, the learning curve with Access is not steep at all it is a very easy system to operate. Because of wizards, it is easier to create a database in less than an hour. Another benefit of Access is that it allows the user to integrate large amounts of data not having to sacrifice performance of the system. Information that has already been made available can be transferred over to the Access program. Microsoft Access can e used for both small and large business environments. However, a large office environment allows access to be programmed from the enterprise resource software.…
- 315 Words
- 2 Pages
Satisfactory Essays -
1. Using quotes from your interviews, describe how each of your three respondents understand the Cold War.…
- 470 Words
- 2 Pages
Satisfactory Essays -
References: Atherton J S (2013) Learning and Teaching; Piaget 's developmental theory [On-line: UK] retrieved 1 October 2014 from http://www.learningandteaching.info/learning/piaget.htm…
- 746 Words
- 3 Pages
Good Essays -
Your research information may be submitted in chart or graph form. You must cite your sources using APA style!!…
- 371 Words
- 2 Pages
Satisfactory Essays -
If a large Vds is applied this voltage with deplete the Inversion layer .This Voltage effectively…
- 3791 Words
- 36 Pages
Good Essays