How can I change the scale of the X Axis in an Area chart in Excel 97? I do not want the scale to begin at 1, but rather to display only the portion of the range where actual data exists.
