Types of Charts in Excel

Different types of charts are better for presenting different types of information. For example, a column chart is great for comparing values of different items, but not for illustrating trends or relationships. If you find that a chart you’ve created isn’t the best fit for your data, you can switch to a different chart type.

Change the Chart Type

1. Select the chart you want to change.
2. Click the Design tab.
3. Click Change Chart Type.
   

   Right-click a chart and select Change Chart Type from the menu.

   The Change Chart Type dialog box appears. It shows the different types of charts available.

4. Select a different chart option.
5. Click OK.
   

Switch Row/Column Data

You can switch the rows and columns of data in a chart so they appear in opposite positions.

1. Select the chart
2. Click the Design tab.
3. Click the Switch Row/Column button.