When you create a chart, Excel checks the number of rows and columns.
In the example below, there are six rows (in Column A, Zone) and three columns (years).
In a chart created automatically by pressing F11, rows from the data table are created on the category axis.
To switch from rows to columns in the category axis, select the chart, and from the Chart menu, select Source Data. In Series in, select Columns. Screenshot // Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
How can I transpose the value and catagory axis in an excel chart.
How can I transpose the value and catagory axis in an excel chart