Is it possible to automaticaly set the Y-value scale of a chart?
A user has to enter values but I don't know what the min and the max of the value is. It is possible to set the min and the max value of the Y-axis to auto in the format axis. But when I set the min value to auto excel always use 0 as the min value. This makes the chart unreadable because the Y-axis becomes to big.
Is it possible to set the min. value to ie 1 less than the min value the user entered?