Hi Everyone,
I wascurious if there is a way to have VBA scale a logarithmic scale to the next base10.
For example, I have written a series of code that generates numerous plots, each with varyingmaximum y values based on data within a column range. Iwould like to find a way for the code search for the maximum value within the column rangeand scale the y-axis to the next base 10 value if it exceeds a minimum. I.e.,if the max y-value were 185, which is higher than the minimum scale of 100, they-axis maximum would be changed to 1000.
Thankyou in advance for any and all help you can provide.
I wascurious if there is a way to have VBA scale a logarithmic scale to the next base10.
For example, I have written a series of code that generates numerous plots, each with varyingmaximum y values based on data within a column range. Iwould like to find a way for the code search for the maximum value within the column rangeand scale the y-axis to the next base 10 value if it exceeds a minimum. I.e.,if the max y-value were 185, which is higher than the minimum scale of 100, they-axis maximum would be changed to 1000.
Thankyou in advance for any and all help you can provide.
