Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

100% Stacked Column Chart (Chart Controls)

This chart type displays multiple data series as stacked columns, and the cumulative proportion of each stacked element always totals 100%.

The 100% stacked column chart is useful for measuring multiple series as a proportion versus time. For example, use this chart type for displaying the proportion of a monthly mortgage payment that is applied to interest and principal over time. In this example, the mortgage payment amount represents 100%, while the interest and the principal values are the two stacked elements that make up one column.

Image of 100% stacked column chart

SeriesChartType value


Number of Y values per point


Number of series

2 or more.

Supports markers


Cannot be combined with:

Doughnut, Pie, Bar, Stacked Bar, Polar, Radar, Pyramid, or Funnel charts.

Custom attributes

DrawingStyle, MaxPixelPointWidth, MinPixelPointWidth, PixelPointDepth, PixelPointGapDepth, PixelPointWidth, PointWidth, StackedGroupName

Stacked series must be aligned. Otherwise, data points will be rendered incorrectly. For more information, see Aligning Data.

© 2015 Microsoft