Change the Layout of Your Charts From Row to Column

Dennis Faas's picture

When you create a chart, MS Excel will check the number of rows and columns. In a chart created automatically, by clicking F11, rows from the data table are created on the category axis. You may, however, sometime later decide that you would like to switch from rows to columns in the category axis.

Fortunately, this is not difficult to accomplish.

Follow the steps below to learn how:

  • Select the chart.
  • From the Chart menu, select Source Data.
  • In Series in, select Columns.  

Told you it was easy!

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet