Creating a Chart

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

Understanding the different chart types

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

Area chart

An area chart emphasizes the trend of each value over time. It 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. It is ideal for showing variations in value over time.

Column Chart

Bar chart

A bar chart is similar to a column chart except it uses horizontal rather than vertical bars. Similar to 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, displaying 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 XP include doughnut, stock XY (scatter), bubble, radar, and surface, as well as cone, cylinder, and pyramid charts.