0

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!

1 Answer 1

1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .