Scary thought...
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Giles" wrote in message
...
Thanks Andy and Jon,
This was most helpful. Ironically though, I decided to keep the axes
constant so my students can see the evolution of Chi-squared as the
degrees
of freedom are increased. As is, I can cover DoFs ranging from 10 to 170
without the curve busting out. For smaller DoFs (i.e, contingency tables)
I'll use a seperate worksheet.
I'll try Jon's code, but currently I'm in the middle of "orientation" - I
can't believe it possible that so many 18 year olds could congregate in
one
place.
Giles
"Giles" wrote:
I'm generating chi-square charts that are dependent of the degrees of
freedom
and probability, hence each chart has a different shape. How can I
automate
the scales to be dependent on individual chi-squared data series. For
example, if a series has DoF of 45 and I'm looking for a probability of
0.1,
then the x-axis has, say, a Min of 15 and a Max of 80, and the Y axix has
a
Min of 0 and a Max of 0.08.
I'd rather not have to resort to VBA
Thanks