I think I've figured out what the problem was.
I was also displaying some other values in this same chart, but those values were sometimes alphanumeric. That causes them to be displayed as zero.
I now made a form where the users can enter a minumum and maximum scale for the Y-axis.
That works...
Hello,
I would like to have users to set the decimalpoints (number format) of a range through a form in excel.
I tried this by recording a macro first then copying this piece of code into a module, but the numberformat is set to the number entered in de form.
For example: if the user enters a 1...
Hello,
i'm a creating a sheet for displaying different ranges of values. With a button i display these values in a chart.
My problem is that the scaling of Y-axis in the chart is not done automaticaly sometimes.
The values on the Y-axis vary from eg 0,01 in one case to 5000 in an other case.
In...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.