Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
GO ! with Microsoft ® Excel 2010 Chapter 3 Analyzing Data with Pie Charts, Line Charts, PowerPoint Presentation
Download Presentation
GO ! with Microsoft ® Excel 2010 Chapter 3 Analyzing Data with Pie Charts, Line Charts,

GO ! with Microsoft ® Excel 2010 Chapter 3 Analyzing Data with Pie Charts, Line Charts,

254 Vues Download Presentation
Télécharger la présentation

GO ! with Microsoft ® Excel 2010 Chapter 3 Analyzing Data with Pie Charts, Line Charts,

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. GO! with Microsoft® Excel 2010 Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools

  2. 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

  3. 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.).

  4. Chart Data with a Pie Chart

  5. Chart Data with a Pie Chart

  6. Format a Pie Chart • Add chart title

  7. 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

  8. Format a Pie Chart

  9. Format a Pie Chart

  10. Format a Pie Chart • Additional formatting • Rotate a pie slice

  11. Format a Pie Chart • Additional formatting • Explode a pie slice

  12. Format a Pie Chart • Inserting a Text Box in a chart • Click Layout tab, Insert group, and then click the Text Box button

  13. 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

  14. 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

  15. 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

  16. Use Goal Seek to Perform What-If Analysis

  17. Objectives • Design a Worksheet for What-If Analysis • Answer What-If Questions by Changing Values in a Worksheet • Chart Data with a Line Chart

  18. 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

  19. 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

  20. 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)

  21. Answer What-If Questions by Changing Values in a Worksheet

  22. Answer What-If Questions by Changing Values in a Worksheet

  23. 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

  24. Chart Data with a Line Chart

  25. 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)

  26. Chart Data with a Line Chart

  27. Chart Data with a Line Chart

  28. Chart Data with a Line Chart