On the tab in the Data group, click the Switch Row / Column button. The rows are switch to columns. We hope this tutorial helps you understand how to switch rows and columns in an Excel Chart.