In most cases, Excel's default behavior of making the x-axis and y-axis of scatter charts intersect at 0 is desirable. But sometimes, your users may want to change that intersection point. An obvious example is when a user needs to highlight just a selected number of years of data but doesn't want to create an entirely new chart.

To reset an axis, follow these steps:

1.       Activate the chart for editing.

2.       Click to select the axis you want to modify.

3.       Choose Selected Axis from the Format menu.

4.       Select the Scale tab.

5.       Type a number in the Value (X or Y) Axis Crosses At text box.

6.       Click OK.

Comment an article   Name   E-mail    Title Available characters: 4000  Notify me of follow-up comments Enter what you see:

No comment posted