Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
x-axis scaling | Excel Discussion (Misc queries) | |||
proper scaling in chart (with time-scale X-axis) | Excel Worksheet Functions | |||
Scaling the x-axis on a line chart | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
2 Axis chart and scaling | Charts and Charting in Excel |