Free Tutorial Central Home | Creating and Formatting Charts |

Microsoft® Excel® 2010 Excel 2010 Creating and Formatting Charts Lesson 3: Creating and Formatting Other Common Charts

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, line-column combination charts, and sparkline 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 a pie of pie chart
  5. create and format a line-column combination chart, and 3.f create and format sparkline charts