How to Switch Rows and Columns in Excel Chart (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to switch rows and columns in an excel chart. Suppose we are creating a chart in excel or working on an existing chart. During the time of working, we may need to modify the chart’s legends. For instance, we need the rows of data on the horizontal axis to appear on the vertical axis rather. So, to solve this we can switch rows and columns to get the data in our expected form.


How to Switch Rows and Columns in Excel Chart: 2 Easy Methods

This article will discuss 2 methods to switch rows and columns in an excel chart. We’ll use the same dataset for both methods to demonstrate how they work. In the dataset, we can see the sales amounts of 2 people for January, February, and March.

2 Methods to Switch Rows and Columns in Excel Chart


1. Use ‘Chart Design’ Tool to Switch Rows and Columns in Excel Chart

We will use the ‘Chart Design’ tool to switch rows and columns in an excel chart in the first method. To illustrate this method we will use the following dataset. To make you understand the process better first we will create a chart with the following dataset. Next, we will switch rows and columns in that chart.

Use ‘Chart Design’ Tool to Switch Rows and Columns in Excel Chart

Let’s see the steps to perform this method.

STEPS:

  • To begin with, select cells (B4:D7).
  • In addition, go to the Insert tab.
  • Furthermore, click on the ‘Insert Column or Bar Chart’ drop-down.
  • Then, select ‘Bar Chart’ from the drop-down which will give us a chart for the above dataset.

Use ‘Chart Design’ Tool to Switch Rows and Columns in Excel Chart

  • Now, click on the chart.
  • Moreover, a new tab named ‘Chart Design’ is available now.
  • After that, from the ribbon click on the ‘Switch Row/Column’ option.

  • Lastly, we get the result like the image below. We can see that the rows and columns of our previous chart have been switched in the new chart.


Similar Readings


2. Switch Rows and Columns in Excel Chart with Transpose Option from Paste Special Feature

We will switch rows and columns in excel charts using the Transpose option from the ‘Paste Special’ feature in the second method. For instance, in this method, we will alter the legends in the excel dataset whereas in the previous example we did that after creating the chart. Follow the below steps to perform this action.

STEPS:

  • Firstly, select cell (B4:D7) and press Ctrl + C to copy the data.

Switch Rows and Columns in Excel Chart with Transpose Option from Paste Special Feature

  • Secondly, select cell B10.
  • Thirdly, go to the Home tab.
  • Select the Paste From the drop-down menu select the option ‘Paste Special’.

Switch Rows and Columns in Excel Chart with Transpose Option from Paste Special Feature

  • So, a new pop-up window named Paste Special appears.
  • Then, check the option Transpose and click on OK.

Switch Rows and Columns in Excel Chart with Transpose Option from Paste Special Feature

  • As a result, we can see the rows and columns of our previous dataset are altered in the image below.

Switch Rows and Columns in Excel Chart with Transpose Option from Paste Special Feature

  • Next, select cells (B10:E12).
  • Then, go to the Insert tab.
  • After that, click on the ‘Insert Column or Bar Chart’ drop-down.
  • Moreover, select ‘Bar Chart’ from the drop-down menu.

  • Finally, we can see the results in the image below. The rows and columns of the dataset have been switched in the excel chart.


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

In conclusion, this article provided a comprehensive overview of how to switch rows and columns in excel charts.  Use the practice worksheet that comes with this article to put your skills to the test. If you have any questions, please leave a comment in the box below. We’ll do our best to respond as soon as possible. Keep an eye on our website for more interesting Microsoft Excel solutions in the future.


Related Articles

Mukesh Dipto
Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo