Is there any way to avoid the following:

When I add a series to a line graph which has an appropriate scale for the y
axis, the scale changes as soon as I click on 'Add Series'. The Values box
populates with ={1} which forces the minimum value on the y axis down to
zero. Even after I replace the ={1} with the data range for values, the scale
remains at the now inappropriate scale with too low of a minimum value,
forcing me to go and make adjustment values to the axis scale. I have lots
of graphing to do and find this irritating and time consuming.

Thanks for any suggestions.



Using Excel 97.