Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Under Axis type, click Text axis, and then click Close. In the Format Axis dialog box, click Axis Options. Right-click the axis that you want to change, and then click Format Axis. To resolve this behavior, format the axis to be a text axis instead of a date axis. If you already created the chart, follow these steps:Ĭlick Category under Category (X) axes and click OK. In step 3 of the Chart Wizard, click the Axes tab.Ĭontinue stepping through the Chart Wizard until the chart is created. Make the changes you want in steps 1 and 2 of the Chart Wizard. Select the data on the worksheet that is to be the source data for the chart.Ĭlick Chart Wizard on the Standard toolbar. If you entered data on the worksheet but did not yet create the chart, follow these steps: To do this, use one of the following methods. ![]() To resolve this behavior, format the axis to be a category axis instead of a time-scale axis. Resolution Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003 When you chart a range of dates that are not consecutive, Microsoft Excel may fill in the missing dates to make the range consecutive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |