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.
    Chart Types

    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.
    Chart Types

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.
    Chart Types

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.