GO with Microsoft Excel 2016 Comprehensive First Edition

  • Slides: 27
Download presentation
GO! with Microsoft Excel 2016 Comprehensive First Edition Chapter 3 Analyzing Data with Pie

GO! with Microsoft Excel 2016 Comprehensive First Edition Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Learning Objectives • Chart Data with a Pie Chart • Format a Pie Chart

Learning 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 • Design a Worksheet for What-If Analysis • Answer What-If Questions by Changing Values in a Worksheet • Chart Data with a Line Chart Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Pie Chart (1 of 4) • Absolute cell reference –

Chart Data with a Pie Chart (1 of 4) • Absolute cell reference – Refers to a cell by its fixed position in the worksheet – Reference will not change when you copy the formula – Dollar signs ($) indicate that a cell reference is absolute • Relative cell reference – Refers to a cell that changes when you copy the formula and paste it to another location Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Pie Chart (2 of 4) Copyright © 2017 Pearson Education,

Chart Data with a Pie Chart (2 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Pie Chart (3 of 4) Copyright © 2017 Pearson Education,

Chart Data with a Pie Chart (3 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Pie Chart (4 of 4) • Data point – A

Chart Data with a Pie Chart (4 of 4) • Data point – A value that originates in a worksheet cell and that is represented in a chart by a data marker • Data marker – In a pie chart, each pie slice is a data marker • Data series – Related data points represented by data markers – Determine the size of each pie slice • Legend – Chart element that identifies the patterns or colors assigned to the categories in the chart – Identifies the pie slices Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Format a Pie Chart (1 of 3) Copyright © 2017 Pearson Education, Inc. All

Format a Pie Chart (1 of 3) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Format a Pie Chart (2 of 3) Copyright © 2017 Pearson Education, Inc. All

Format a Pie Chart (2 of 3) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Format a Pie Chart (3 of 3) Copyright © 2017 Pearson Education, Inc. All

Format a Pie Chart (3 of 3) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Edit a Workbook and Update a Chart Copyright © 2017 Pearson Education, Inc. All

Edit a Workbook and Update a Chart Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Use Goal Seek to Perform What-If Analysis (1 of 2) Copyright © 2017 Pearson

Use Goal Seek to Perform What-If Analysis (1 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Use Goal Seek to Perform What-If Analysis (2 of 2) Copyright © 2017 Pearson

Use Goal Seek to Perform What-If Analysis (2 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Design a Worksheet for What-If Analysis (1 of 2) Copyright © 2017 Pearson Education,

Design a Worksheet for What-If Analysis (1 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Design a Worksheet for What-If Analysis (2 of 2) Copyright © 2017 Pearson Education,

Design a Worksheet for What-If Analysis (2 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Answer What-If Questions by Changing Values in a Worksheet (1 of 4) Copyright ©

Answer What-If Questions by Changing Values in a Worksheet (1 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Answer What-If Questions by Changing Values in a Worksheet (2 of 4) Copyright ©

Answer What-If Questions by Changing Values in a Worksheet (2 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Answer What-If Questions by Changing Values in a Worksheet (3 of 4) Copyright ©

Answer What-If Questions by Changing Values in a Worksheet (3 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Answer What-If Questions by Changing Values in a Worksheet (4 of 4) Copyright ©

Answer What-If Questions by Changing Values in a Worksheet (4 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (1 of 7) Copyright © 2017 Pearson Education,

Chart Data with a Line Chart (1 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (2 of 7) Copyright © 2017 Pearson Education,

Chart Data with a Line Chart (2 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (3 of 7) • Axis – A line

Chart Data with a Line Chart (3 of 7) • Axis – A line that serves as a frame of reference for measurement – It borders the chart plot area • Plot area – The area bounded by the axes, including all the data series • Category axis – Also known as the x-axis – The area along the bottom of a chart that identifies the categories of data • Value axis – Also known as the y-axis – Area along the left side of a chart that shows the range of numbers for the data points Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (4 of 7) Copyright © 2017 Pearson Education,

Chart Data with a Line Chart (4 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (5 of 7) Copyright © 2017 Pearson Education,

Chart Data with a Line Chart (5 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (6 of 7) Copyright © 2017 Pearson Education,

Chart Data with a Line Chart (6 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Chart Data with a Line Chart (7 of 7) Copyright © 2017 Pearson Education,

Chart Data with a Line Chart (7 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Questions Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Questions Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Copyright © 2017 Pearson Education, Inc. All Rights Reserved.

Copyright © 2017 Pearson Education, Inc. All Rights Reserved.