I have 10 pivot charts, driven off the same data, showing different
things but with the same y-axis numbering (simply zero to 100 or
whatever). So as not to mislead, I wish to same size the y-axis across
all graphs. At present some are zero to 30, others zero to 100. Is
there an easy way or macro to ensure that the y-axis is set the same
across all pivot graphs using the highest as the benchmark?

Thanks

Mike