Introduction
Charts
Video: Working with Charts in Excel 2010
The answers to questions like these can become much clearer when data is represented as a chart. Excel has various types of charts, so you can choose one that most effectively represents your data.
Optional: You can download this example for extra practice.
Types of charts
Click the arrows in the slideshow below to view examples of some of the types of charts available in Excel.
Excel has a variety of chart types, each with its own advantages. Click
the arrows to see some of the different types of charts available in
Excel.
Column charts use vertical bars to represent data. They can work with many different types of data, but they're most frequently used for comparing information.
Line charts are ideal for showing trends. The data points are connected with lines, making it easy to see whether values are increasing or decreasing over time.
Pie charts make it easy to compare proportions. Each value is shown as a
slice of the pie, so it's easy to see which values make up the
percentage of a whole.
Bar charts work just like column charts, but they use horizontal instead of vertical bars.
Area charts are similar to line charts, except the areas under the lines are filled in.
Surface charts allow you to display data across a 3D landscape. They
work best with large data sets, allowing you to see a variety of
information at the same time.Identifying the parts of a chart
Click the buttons in the interactive below to learn about the different parts of a chart.
To create a chart:
- Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart.
- Click the Insert tab.
- In the Charts group, select the desired chart category (Column, for example).
- Select the desired chart type from the drop-down menu (Clustered Column, for example).
- The chart will appear in the worksheet.
Chart tools
Once you insert a chart, a set of chart tools arranged into three tabs will appear on the Ribbon. These are only visible when the chart is selected. You can use these three tabs to modify your chart.
To change chart type:
- From the Design tab, click the Change Chart Type command. A dialog box appears.
- Select the desired chart type, then click OK.
To switch row and column data:
Sometimes when you create a chart, the data may not be grouped the way you want. In the clustered column chart below, the Book Sales statistics are grouped by Fiction and Non-Fiction, with a column for each year. However, you can also switch the row and column data so the chart will group the statistics by year, with columns for Fiction and Non-Fiction. In both cases, the chart contains the same data—it's just organized differently.
- Select the chart.
- From the Design tab, select the Switch Row/Column command.
- The chart will readjust.
To change chart layout:
- Select the Design tab.
- Click the More drop-down arrow in the Chart Layouts group to see all of the available layouts.
- Select the desired layout.
- The chart will update to reflect the new layout.
Some layouts include chart titles, axes, or legend labels. To change them, place the insertion point in the text and begin typing.
To change chart style:
- Select the Design tab.
- Click the More drop-down arrow in the Chart Styles group to see all of the available styles.
- Select the desired style.
- The chart will update to reflect the new style.
To move the chart to a different worksheet:
- Select the Design tab.
- Click the Move Chart command. A dialog box appears. The current location of the chart is selected.
- Select the desired location for the chart (choose an existing worksheet, or select New Sheet and name it).
- Click OK. The chart will appear in the new location.
