In Microsoft Excel 2000, when you change the chart type, the scale of the
category (X) axis may also be changed.
↑ Back to the top
This behavior occurs when you select a series and change its chart type.
Changing the chart type for a series is different from changing the chart
type for a group of data points. Based on the chart type you select, the
Value (Y) axis crosses between categories check box may be cleared in the Format Axis dialog box.
↑ Back to the top
To work around this behavior, follow these steps:
| 1. | Select the x-axis in the chart.
|
| 2. | On the Format menu, click Selected Axis, and then click the Scale tab.
|
| 3. | Click to select the Value (Y) axis crosses between categories check box, and then click OK. |
↑ Back to the top
For more information about chart types, click Microsoft Excel Help on the Help menu, type select a different chart type in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top