setting scale on chart automatically

  • Thread starter Thread starter Sanford Lefkowitz
  • Start date Start date
S

Sanford Lefkowitz

I am having users select a time series (line) chart from a drop down menu. (I
have a bunch of data on a separate page. The drop down menu pulls in the
requested data to a defined range and draws the chart). Frequently, the scale
on the Y axis that Excel chooses is highly sub-optimal. I don't want the user
to have to manually adjust the axes. Is there any way I can specify the scale
on the axes without manual adjustments?

Thanks
 
Back
Top