Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel

 

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 ColumnsScreenshot // Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel



2 thoughts on “Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>