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?

Liam -

Elsewhere on Tushar's site is an AutoChart Manager, which lets you set
the axis scales more flexibly than either setting a constant value or
letting Excel set them. And on my site, I describe the process to set up
something like this in VBA:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Liam wrote:
> 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


Jon Peltier <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Liam -
>
> Elsewhere on Tushar's site is an AutoChart Manager, which lets you set
> the axis scales more flexibly than either setting a constant value or
> letting Excel set them. And on my site, I describe the process to set up
> something like this in VBA:
>
> http://peltiertech.com/Excel/Charts/...nkToSheet.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> Liam wrote:
> > 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?
>

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?

>-----Original Message-----
>Liam -
>
>Elsewhere on Tushar's site is an AutoChart Manager,
which lets you set
>the axis scales more flexibly than either setting a
constant value or
>letting Excel set them. And on my site, I describe the
process to set up
>something like this in VBA:
>
>
http://peltiertech.com/Excel/Charts/...eLinkToSheet.h
tml
>
>- Jon
>-------
>Jon Peltier, Microsoft Excel MVP
>Peltier Technical Services
>http://PeltierTech.com/Excel/Charts/
>_______
>
>Liam wrote:
>> 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?
>
>.
>

Liam -

What you need to do is write an algorithm to compute the axis scale
parameters from your data. Here's a good example posted by Stephen Bullen:

http://www.google.com/groups?selm=VA...88%40bmsltd.ie

He wrote it in VBA, but it's readily converted into worksheet formulas.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Liam wrote:

> 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?
>
>
>>-----Original Message-----
>>Liam -
>>
>>Elsewhere on Tushar's site is an AutoChart Manager,
>
> which lets you set
>
>>the axis scales more flexibly than either setting a
>
> constant value or
>
>>letting Excel set them. And on my site, I describe the
>
> process to set up
>
>>something like this in VBA:
>>
>>
>
> http://peltiertech.com/Excel/Charts/...eLinkToSheet.h
> tml
>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>http://PeltierTech.com/Excel/Charts/
>>_______
>>
>>Liam wrote:
>>
>>>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?
>>
>>.
>>

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.


Liam <(E-Mail Removed)> wrote in message
news:1207801c41542$b6c1de40$(E-Mail Removed)...
> 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?
>
> >-----Original Message-----
> >Liam -
> >
> >Elsewhere on Tushar's site is an AutoChart Manager,
> which lets you set
> >the axis scales more flexibly than either setting a
> constant value or
> >letting Excel set them. And on my site, I describe the
> process to set up
> >something like this in VBA:
> >
> >
> http://peltiertech.com/Excel/Charts/...eLinkToSheet.h
> tml
> >
> >- Jon
> >-------
> >Jon Peltier, Microsoft Excel MVP
> >Peltier Technical Services
> >http://PeltierTech.com/Excel/Charts/
> >_______
> >
> >Liam wrote:
> >> 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?
> >
> >.
> >