Page 1 of 17PREVNEXT

Charts III: Create a professional-looking chart

Customize chart appearance
You know how to create a chart in Microsoft® Office Excel 2003 and choose the most effective chart type. Now learn how to customize it, enhance its appearance, and change any of the information on the chart.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Customize charts by using colors, adding shading and shadows to chart formatting, and applying number formats.
  • Make revisions to any information on the chart.
  • Reverse the order in which values are displayed on the chart.
  • Revise numbers on the value axis.

Before you begin

You should already be familiar with how to create charts, or you should complete the course Charts I: How to create a chart.

To learn how to choose a chart type, complete the course Charts II: Choose the right chart type.

Customize your charts to make them more attractive, memorable, and effective. This course shows you how easy it is to add visual interest to charts and make them more meaningful with simple built-in formatting effects.

Did you know that a chart axis can start at a number other than zero? Find out how. You'll also learn how to make changes to the information on your charts, from the basics of revising chart titles to making data appear in a different order on a chart without reorganizing your worksheet.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column.

When you're done reading this page, click Next to start the first lesson.

Page 1 of 17PREVNEXT