# 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.

### 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.

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.

• 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.

### 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.

• Secondly, select cell B10.
• Thirdly, go to the HomeÂ tab.
• Select the Paste From the drop-down menu select the option â€˜Paste Specialâ€™.

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

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

• 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.

## 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

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

Advanced Excel Exercises with Solutions PDF