Saturday, July 20, 2013

How to Label Category Axis (X) in Excel 2007


1. Open Excel 2007 and open a workbook. Click the 'Office' button and select 'Open.' Browse your files and locate the workbook you wish to use, and double click it.
2. Locate a range of data that contains row headers. Highlight the data and the row header information. The row header information will appear in the label category x axis. Click 'Insert' on the ribbon. Select a 'Line' chart to represent your data. The chart appears in your worksheet.
3. Click the outside border of the chart. The Chart Tools tab appears above the ribbon. Select the 'Layout' tab. Click the 'Axis Title' icon. A drop down list appears. Click the 'Primary Horizontal Axis Title.' Select 'Title below Axis.' Your horizontal or x axis is now labeled.

Blogger news