Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I automate chart axes
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I automate chart axes
Hi,
The scale min and max values can either be automatic or static fixed values. If you want dynamic fixed values you will have to resort to vba. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Giles" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I automate chart axes
This web page explains how to use VBA to link axis scales to calculated
worksheet values: http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, The scale min and max values can either be automatic or static fixed values. If you want dynamic fixed values you will have to resort to vba. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Giles" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I automate chart axes
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I automate chart axes
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having two X-axes on same chart | Excel Discussion (Misc queries) | |||
Automate a graph/chart? | Excel Discussion (Misc queries) | |||
XY-Chart with 4 axes | Charts and Charting in Excel | |||
Is it possible to create 3 Y-axes in one chart? | Charts and Charting in Excel | |||
CHART AxES TITLE | Excel Discussion (Misc queries) |