Chart Types

Learning Outcomes

  • Modify chart type.

Once you have created a chart, or if you are given a worksheet that contains a chart, it is very easy to change the chart type.

  1. Click on the chart you wish to change. The Design tab should appear in the ribbon area.
  2. Click on Change Chart Type button

An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13. In the ribbon there is a green box with two numbers 1 and 2. The first number is green and shows where the switch row/column button is. The second number shows how to change the chart type.

  1. Click on the type of chart you would like.

A change chart type dialog box is open with a line chart selected.

From this same window, you can also switch the data that is being charted. For example, you can switch which data from a row to a column or change which data is arranged on the x- or y-axis.

An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13. A green arrow is pointing to a green box which is showing options on how to adjust the chart.

Practice Question