dynamic chart - scale minimum

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 wrote in 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/...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 wrote in message
...
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?

.