Transcript Format a Pie Chart

GO! with Microsoft® Excel 2010
Chapter 3
Analyzing Data with Pie Charts, Line Charts,
and What-If Analysis Tools
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
1
Objectives
• Chart Data with a Pie Chart
• Format a Pie Chart
• Edit a Workbook and Update a Chart
• Use Goal Seek to Perform What-If
Analysis
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
2
Chart Data with a Pie Chart
• Pie chart
– Charts only one data series
– Shows the size of items proportionally
– Requires two ranges to be selected
• One range contains the labels for each slice of
the pie (Legend).
• Other range contains the values that add up to
a total (Do NOT include the total in the range.).
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
3
Chart Data with a Pie Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
4
Chart Data with a Pie Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
5
Format a Pie Chart
• Add chart title
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
6
Format a Pie Chart
• Applying legends and data labels
– Select Chart Tools, Layout tab, and then, in
the Labels group, click the Legend button
– In the Labels group, click the Data Labels
button, and then More Data Label Options
– In the Format Data Labels dialog box,
select Label Options, and then Label
Contains and then check Category Name
and Percentage
– Under Label Position, click Center option
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
7
Format a Pie Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
8
Format a Pie Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
9
Format a Pie Chart
• Additional formatting
– Rotate a pie slice
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
10
Format a Pie Chart
• Additional formatting
– Explode a pie slice
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
11
Format a Pie Chart
• Inserting a Text Box in a chart
– Click Layout tab, Insert group, and then
click the Text Box button
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
12
Edit a Workbook and Update
a Chart
• Editing a workbook
– Changing data in a workbook
• Chart data markers adjust automatically to
accurately reflect changes.
– Insert WordArt in a worksheet
• Allows decorative effects, such as shadowed or
mirrored text
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
13
Use Goal Seek to Perform
What-If Analysis
• What-If analysis
– Process of changing the values in cells to
see how those changes affect the outcome
of formulas in a worksheet
• Goal Seek
– Excel tool that finds the input needed in
one cell to arrive at the desired result in
another cell
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
14
Use Goal Seek to Perform
What-If Analysis
• Goal Seek dialog box
– On the Data tab, in the Data Tools group, click
What-If Analysis, and then click Goal Seek
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
15
Use Goal Seek to Perform
What-If Analysis
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
16
Objectives
• Design a Worksheet for What-If
Analysis
• Answer What-If Questions by
Changing Values in a Worksheet
• Chart Data with a Line Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
17
Design a Worksheet for
What-If Analysis
• Percentage rate of increase
– The percent by which one number
increases over another number
– Amount of increase/base
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
18
Design a Worksheet for
What-If Analysis
• Excel order of operations
– Expressions within parentheses first
– Exponentiation, if present, before
multiplication and division
– Multiplication and division before addition
and subtraction
– Consecutive operators with the same level
of precedence calculate left to right
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
19
Design a Worksheet for
What-If Analysis
• Calculate a value given the increase
– The result when one number is increased a
certain percentage
• Base * (100% + percent increase)
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
20
Answer What-If Questions by
Changing Values in a Worksheet
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
21
Answer What-If Questions by
Changing Values in a Worksheet
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
22
Chart Data with a Line Chart
• Line chart
– Displays trends over time
– Displays time along bottom axis
– Connects data points with a line
– Illustrates trends through curve and
direction of line
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
23
Chart Data with a Line Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
24
Chart Data with a Line Chart
• Chart formatting capabilities
– Format the category axis (x-axis)
– Format the value axis (y-axis)
– Format the chart area (Ex: Border Color,
Border Styles, and Chart Elements)
– Format the plot area (Ex: background)
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
25
Chart Data with a Line Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
26
Chart Data with a Line Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
27
Chart Data with a Line Chart
with Microsoft® Excel 2010
© 2011 Pearson Education, Inc. Publishing as Prentice Hall
28