Creating Charts with Excel 2007 by sid68361

VIEWS: 6 PAGES: 2

									Creating Charts with Excel 2007

Introduction and Course Objectives ................................................................................ 1

Creating and Manipulating Charts ................................................................................... 2
   Setting up Data to Chart ............................................................................................ 4
   Three Ways to Generate Charts ................................................................................ 5
   Moving a Chart........................................................................................................... 7
   Resizing a Chart ........................................................................................................ 8
   Changing Chart Type................................................................................................. 8
   Deleting a Chart ......................................................................................................... 9

Understanding Chart Vocabulary .................................................................................. 10

Creating Charts with Multiple Series ............................................................................. 12

Exercise 1: Creating Column Charts ............................................................................. 13

Formatting Charts.......................................................................................................... 15
   Adding Chart Titles .................................................................................................. 15
   Displaying Axes Titles.............................................................................................. 15
   Adding Gridlines....................................................................................................... 16
   Changing Legend Options ....................................................................................... 16
   Applying Chart Layouts............................................................................................ 18

Modifying the Worksheet Data in a Chart...................................................................... 19
  Editing Data Updates a Chart .................................................................................. 19
  Update a Chart Using Sorting .................................................................................. 19
  Changing the Data Range ....................................................................................... 20
  Using the Switch Row/Column Button ..................................................................... 21
  Using the Select Data Source Options..................................................................... 22
  Changing the Way Data Series Are Plotted ............................................................. 23
  Using Value Data Labels as Text............................................................................. 24

Exercise 2: Modifying Existing Charts ........................................................................... 26

Working with Chart Objects........................................................................................... 28
  Selecting Chart Objects ........................................................................................... 28
  Formatting Parts of the Chart................................................................................... 29
  Adding Unattached Text .......................................................................................... 34

Exercise 3: Creating and Formatting Charts ................................................................. 36

Graphing Noncontiguous Ranges ................................................................................. 38

Creating Bar Charts....................................................................................................... 39


Creating Charts with Excel 2007
www.micros.umsl.edu
Creating Tornado Charts............................................................................................... 40
   Steps for Creating a Two-Way Tornado Chart ......................................................... 40
   Creating a One-Way Tornado Chart ........................................................................ 43

Creating Line Charts ..................................................................................................... 44

Exercise 4: Creating Line Charts................................................................................... 46

Creating XY (Scatter) Charts......................................................................................... 48

Exercise 5: Creating XY (Scatter) Charts ...................................................................... 50

Creating Gantt Charts ................................................................................................... 51

Creating Pie Charts ....................................................................................................... 54
   Creating an Exploded Pie Chart .............................................................................. 55
   Dealing with Small Pie Slices................................................................................... 57
   Creating a Pie of Pie or Bar of Pie Chart ................................................................. 57
   Changing Pie of Pie or Bar of Pie Labels................................................................. 59

Exercise 6: Creating Pie Charts .................................................................................... 60

Adding a Trendline ........................................................................................................ 61
   Why Are Trendlines Used? ...................................................................................... 61
   Types of Trendlines ................................................................................................. 61
   Creating Trendlines.................................................................................................. 62
   Deleting a Trendline................................................................................................. 64

Creating 3-D Charts ...................................................................................................... 65
   Choosing a 3-D Chart .............................................................................................. 65
   Rotating and Formatting a 3-D Chart ....................................................................... 65

Creating Combination Charts ........................................................................................ 68
   Charts with the Same Range of Values ................................................................... 68
   Charts with a Different Range of Values .................................................................. 69
   Plot a Secondary Axis.............................................................................................. 69

Exercise 7: Working with Combination Charts .............................................................. 70

Creating Pictographs (Optional Topic) .......................................................................... 71

Setting the Default Chart Type (Optional Topic)............................................................ 74

Appendix A: Excel 2007 Chart Types............................................................................ 75
Appendix B: Sort Dialog Box ......................................................................................... 87
Appendix C: Printing a Chart........................................................................................ 89
Appendix D: Solutions to Exercises .............................................................................. 90


Creating Charts with Excel 2007
www.micros.umsl.edu

								
To top