Great Swap Axis In Excel

A common task of many excel users is to need to change the position of the axis of your graph in excel.

Swap axis in excel. In the Format Axis pane in the right click the Axis Options button and change the number in the Major box in the Units section. Right click the axis you want to change select Format Axis from context menu. Every new chart in Excel comes with two default axes.

But it does not tell you. It should give you what you want. Swap the data columns to end with X_data in column A and Y_data in column B.

In this tutorial I will show you how to switch the X and Y axis in an excel graph. For example if your data looks like this with Sales Regions in the column headings and. If you are in Excel 2010 or 2007 it will open the Format Axis dialog.

On the Format tab in the Current Selection group click the arrow in the Chart Elements box and then click the horizontal category axis. Then it hit me. The chart uses text from your source data for axis labels.

A new window will open. After you switch rows to columns in the chart the columns of data are plotted on the vertical axis and the rows of data are plotted on the horizontal axis. If you dont want to change the text of the.

If you have a worksheet with data in columns that you need to rotate to rearrange it in rows use the Transpose feature. Click on a table Go to Insert Charts Clustered Column this will give you the default chart. X_data in first column and Y_data in second column.