100 Percent Stacking Bar Charts

Use the IsYAxis100Percent and IsY2Axis100Percent properties of the AxisObject to scale the Y axis of stacking bar charts to a common 100 percent value. When IsYAxis100Percent or IsY2Axis100Percent is False, the actual series data is used. When IsYAxis100Percent or IsY2Axis100Percent is True, the data is scaled so that all bars are the same height and each series is scaled to a total of 100 percent.

The IsYAxis100Percent and IsY2Axis100Percent properties can be accessed through the Property Pages by choosing the Axes tab, highlighting the Y or Y2 series from the left window pane and clicking the Is100Percent checkbox.