View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Barb
 
Posts: n/a
Default Add series to line graph

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.