Is there any way I can create a bar chart based on data but make only one bar stacked? Like this (see the last bar):

enter image description here

I made this image by adding a shape to the last bar. Is it possible to create a chart like this natively in Excel, just using data in your sheet?

Any help would be greatly appreciated!


Here is one way:

  1. Insert the value to stack in a separate column, using 0 for those columns where you don't want to stack anything.

enter image description here

  1. Insert a stacked column chart:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.