Pivot Chart Value Axis Scaling Question
 

Question: Is there a way with VBA to dynamically control the value axis
labels
based on the data values being displayed at any given time?

Details: I have a pivot chart that displays 3 data series.

Series 1 values range from 17 to 106.
Series 2 values range from 1 to 18.
Series 3 values range from 0 to 1.

When I display all three series on the chart, the value axis labels run from
1 to 120 with major unit lines at intervals of 20.

When I remove Series 1, the chart automatically adjusts itself and the
value axis labels run from 1 to 20 with lines at intervals of 2, thus
nicely accommodating the value ranges of Series 1 and Series 2.

All this is fine. But when I remove Series 2, leaving only Series 3,
the labels run from 1 to 1.2 with interval spacing of .2. Since these
values are counts, it makes little sense to show decimal values.

Can anyone provide advice on how to keep these axis labels from
showing decimal values, if a user removes Series 1 and Series 2?

Thanks.

- Bob