We are continually faced with a series of great opportunities brilliantly disguised as insoluble problems
Bookmark with:
 |
FREE initial consultation |  |
Secure Online Clients Area |
 |
Worldwide service |  |
Choice Of payments [Fixed Fee or Hourly or Daily rate] +44 (0) 208 209 0835/ 07956877605 |
» MS Excel » how to change the layout of the chart from rows to column in ms excel
CATEGORY: Excel Keyboard Shortcuts VERSIONS: All Microsoft Excel Versions
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 Columns.
how to change the layout of the chart from rows to column in ms excel
Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft ExcelCATEGORY: Excel Keyboard Shortcuts VERSIONS: All Microsoft Excel Versions
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 Columns.
Practical advice for business
