dynamic chart - scale minimum

  • Thread starter Thread starter Liam
  • Start date Start date
L

Liam

I'm using Tushar Mehta's dynamic chart method for
plotting a normal curve, and the scale minimum for the X-
axis (set in "auto" mode) seems to want to be zero, even
if the curve is no where near it (even when the mean is
33 standard deviations away from zero!). Any idea how
Excel decides what the min value should be? Can I put in
a formula instead of a constant to override the number it
chooses?
 
Mr. Peltier

I am using Mr. Tushar Mehtas addin <autochart manager> which is extremely
useful and I am using it a lot.
But recently my brother wanted to draw nearly fifty charts every month. so I
was thinking of attempting
a vba programme basesd on tushar mehtas add in and your webpage given below
is a timely boon . I shall study that
programme
thank you once again
 
Thanks, Jon, this is great. However, all the majorunit
values have too many decimals, depending on whatever the
minimumscale value has. For example, if the min value is
100.456, then all the majorunit values will be 110.456,
120.456, etc., when 100, 110, 120 would be more logical,
not to mention presentable. The question is: how do you
round down the minimumscale number to
something "reasonable" when you have no foreknowledge of
the scale of the numbers? The chart must be able to deal
with numbers that could be anything, e.g. 0.00001 or
10,000. Is there a function that tells you the magnitude
of a number?
 
If I have understood croorectly:----

regarding the round values for the axes I used roundup(max(.)) and
rounddown(min(..)) values giving them some names and using these names. will
this not be alright and is there error here??
my max and min were 10.5848 and 10.3874 respy. I used round(max(>>),0) I
got 11 and similarly rounddown(min(...),0) I got 10. instead of roundup or
down digits as 0 I can use 1 or 2 or even -1 or -2. .
Even for ranges of values within brackets of max and min I used the
dynamic range of(mehta and peltier) and giving names to these dynamicrange
formula I am still experimenting with this. thanks for ideas.
regards.
 
Back
Top