Hi,
I have some charts for which i have set up text boxes to specify the max and min y axis values as well as the major unit increment. This works well and i am happy with it.
However, i would like to have the option to reset the charts to autoscaleing via a command button. I have set up code to clear the min, max and increment text boxes but i cannot find out how to reset the chart to autoscaling.
On closing the form and re-opening the form the previous setting for min max remain which is a problem, so i would also like the chart to start as autoscaling after re-opening the form. Any help appreciated.
I have some charts for which i have set up text boxes to specify the max and min y axis values as well as the major unit increment. This works well and i am happy with it.
However, i would like to have the option to reset the charts to autoscaleing via a command button. I have set up code to clear the min, max and increment text boxes but i cannot find out how to reset the chart to autoscaling.
On closing the form and re-opening the form the previous setting for min max remain which is a problem, so i would also like the chart to start as autoscaling after re-opening the form. Any help appreciated.