How to Change Interval of Category Axis in an Excel Chart

When you create a chart, Microsoft Excel 2007 sets the interval of the category axis. You can change this to reflect the interval you want to be represented in between each tick mark.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Microsoft Excel 2007

1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you want to change the interval of the category axis.
2. Click in the white area of the chart so the whole chart is selected. You can tell the entire chart is selected because a light blue outline will surround the entire chart.
3. Select the "Format" tab at the top of the Excel screen to display the "Format" ribbon. Locate the "Current Selection" group–it is the first group in the "Format" ribbon.
4. Click the "Chart Elements" arrow to display the drop-down list. This is the top option in the "Current Selection" section of the "Format" ribbon. Choose "(Category) Axis" from the drop-down list.
5. Press the "Format Selection" button right underneath the "Chart Elements" drop-down list. The "Format Axis" dialog box will appear on the screen. Click "Axis Options" if necessary to display the options for changing the interval of the category axis.
6. Type the number of units you have to use in the "Interval between tick marks" text box at the top of the "Format Axis" dialog box.
7. Click the "Close" button to close the "Format Axis" dialog box and return to your Excel chart. You will now see that the interval for the category axis has changed.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.