Enabling Stack Percentage

The percentage of each bar part in a stacked bar is calculated and displayed in the middle of the bar. Percentage values for zero percent or one hundred percent are not displayed.You can display percentage values for each series in the stacked bar. Only one stacked bar is displayed. This is not applicable in a normal bar series.

  1. From the chart legend, click Select Measures.
  2. Click the Stack Percentage check box.
  3. Optionally, select the Show Data Points check box to display the data points in your chart. You can also specify a rotation angle.
    Note: When Show Data Points is selected, the values are displayed on top of each of the bar parts when any of the stacked bar series are selected. The total value is displayed below the stacked bar on the X axis.
  4. Click OK.