In PowerPoint, there is no standard option to create a combined stacked and clustered column chart. Here is a work around, taking the stacked column chart as the basis.

  1. Set the gap width to zero (in the format data series menu) to create the white breaks in between the columns
  2. Adjust the data points manually. The first stacked column goes in regularly. The second stacked column (that should have a different color scheme) gets added on top of the first one. But for data points of the second column, you zero out the values of the first one. Sounds a bit complicated, but the visual example below should make it clear.

If you liked this post, why not subscribe to daily updates about presentation design via email? Just blog posts, no spam, or you can follow Jan on Twitter to never miss a thing.