I have a set of charts that I use that I copy and paste external data into
the sheet to look at the graph it creates. The problem I have is the y scale
makes the line too flat. While I know I can override the scale the problem
is I am pasting 40 different sets of data in one after another so to reset
the scale each time is too time consuming. Can I keep the scale set on auto
but not have it go down to zero all the time?