Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003
To resolve this behavior, format the axis to be a category axis instead of a time-scale axis. To do this, use one of the following methods.
Method 1
If you entered data on the worksheet but did not yet create the chart, follow these steps:
- Select the data on the worksheet that is to be the source data for the chart.
- Click Chart Wizard on the Standard toolbar.
- Make the changes you want in steps 1 and 2 of the Chart Wizard.
- In step 3 of the Chart Wizard, click the Axes tab.
- Click Category under Category (X) axis.
- Continue stepping through the Chart Wizard until the chart is created.
Method 2
If you already created the chart, follow these steps:
- Click the chart to select it.
- On the Chart menu, click Chart Options.
- Click the Axes tab.
- Click Category under Category (X) axes and click OK.
Microsoft Office Excel 2007
To resolve this behavior, format the axis to be a text axis instead of a date axis. To do this, follow these steps:
- Right-click the axis that you want to change, and then click Format Axis.
- In the Format Axis dialog box, click Axis Options.
- Under Axis type, click Text axis, and then click Close.