Change the Layout of Your Charts From Row to Column
- by Carol Bratt on 20090917 @ 10:37AM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: chart, rows, category axis, data)
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!
Infopackets Game of the Week: Lottso!
Click any thumbnail to view a full screen sample.
[ Download (Free Trial) ~ 16.52 MB | Read Game Details ]
