View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Giles Giles is offline
external usenet poster
 
Posts: 11
Default 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