Change the Layout of Your Charts From Row to Column
by Carol Bratt on September, 17 2009 at 08:09AM EDT
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!
Filed under:
Rate this article:
Need Help? Ask!
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.