Switch Axes in Excel

Let’s say you have data on the hours you spent on your work in a week. The data is separated into each day, and the day is separated into morning, afternoon, and night.

In order to switch an axis in excel, you have to perform the following steps.

  1. Click on a table,
  2. Go to Insert >> Charts >> Clustered Column (this will give you the default chart),
  1. Click on the chart and choose the Design tab,
  2. Go to Data >> Switch Row / Column.
  3. Now, the X-axis switched with the Y-axis without the need for transposing data.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.