Free Tutorial Central Home | Creating and Formatting Charts in Excel 2007 |

Microsoft® Excel® 2007: Creating and Formatting Charts With Lots of Tips and Tricks Lesson 3: Creating other Common Charts and Exploring Chart Formatting Options

In Lesson 2, you learned how to change the location of a chart, apply predefined quick layouts and quick styles, and select and format individual chart elements using pie, column, and bar charts.

In this lesson, you will learn to create other common chart types including line, stacked area, exploded pie, pie of pie, and line-column combination charts. You will also learn more about chart formatting options.




Click the "Download" button to download this free lesson in PDF format.

Objectives

  1. create and format a line chart
  2. create and format a stacked area chart
  3. create and format an exploded pie chart
  4. create and format pie of pie chart
  5. create and format a line-column combination chart

Key Terms

primary chart

Reset to Match Style command

secondary chart

Switch Row/Column command button

area chartpie of pie chart

combination chart

exploded pie chart

line chart

line-column combination chart