» Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
CATEGORY - Excel Keyboard Shortcuts
VERSION - 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.
Book Store:
Recommended Books:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Advanced modelling in finance using Excel and VBA
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Accounting for Dummies
- Understanding Financial Statements
No comments have been submitted.
