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.
Back to the top
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.
Bookmarks