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 CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!