If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
dynamic chart - scale minimum
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? |
#3
|
|||
|
|||
dynamic chart - scale minimum
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? |
#4
|
|||
|
|||
dynamic chart - scale minimum
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? . |
#5
|
|||
|
|||
dynamic chart - scale minimum
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? . |
#6
|
|||
|
|||
dynamic chart - scale minimum
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? . |
Thread Tools | |
Display Modes | |
|
|