Chat with us, powered by LiveChat

Types of Charts in Excel

How to Change Chart Types 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