Creating a Chart

Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.

Understanding the different chart types

Excel 2003 allows you to create many different kinds of charts.

Area chart

An area chart emphasizes the trend of each value over time. An area chart also shows the relationship of parts to a whole.

Area Chart

Column chart

A column chart uses vertical bars or columns to display values over different categories. They are excellent at showing variations in value over time.

Column Chart

Bar chart

A bar chart is similar to a column chart, except these use horizontal instead of vertical bars. Like the column chart, the bar chart shows variations in value over time.

Bar Chart

Line chart

A line chart shows trends and variations in data over time. A line chart displays a series of points that are connected over time.

Line Chart

Pie chart

A pie chart displays the contribution of each value to the total. Pie charts are an effective way to display information when you want to represent different parts of the whole, or the percentages of a total.

Pie Chart

Other charts

Other charts that can be created in Excel 2003 include Doughnut; Stock XY (scatter); Bubble; Radar; Surface; and Cone, Cylinder, and Pyramid charts.