Stacked bar (bar height equals larger value, not total)

I'm trying to make a stacked bar graph, wherein the smaller bar is placed within the larger bar. I'm struggling to explain this without a simple example, so here is what I mean:

The total value is 10 pizzas sold. 8 were plain pizzas and 2 had toppings.

In the typical format, one bar would be 8 and the other would be 2. The entire stack would equal 10.

In my version, the bar height would only be 8, but the first two units would be a different color or pattern to represent the pizza with toppings. It would be implied that the height of the entire bar is the plain pizza (8 slices mmm).

Thank you in advance for your advice on creating this in Excel 2013 version!

Thanks for the quick reply!

That's what I want to happen visually, but my default settings create a bar of 10 total units (a correct 8 to 2 split, but that's not our goal visually).

Is this what you want (?) - you can completely overlap the series by setting Series Overlap to 100%.

EXCEL_2019-11-09_10-26-39.png

Originally Posted by MrShorty

...Then use column A and column C in the stacked bar/column chart. Is your spreadsheet amenable to something like that?

Yes, that's a workable idea. I didn't think of just creating an additional column!

Originally Posted by Mrrrr

Is this what you want (?) - you can completely overlap the series by setting Series Overlap to 100%.

Attachment 648906

Yes - that works very well. Is there a way to make it a dual graph too? Such that we're comparing the plain and topping slices in one overlapped bar; then the plain and topping calzones in another overlapped bar on the same graph? If there is a way to represent that, I think this would be considered solved.

See if attached is ok.

Thank you, Mrrr. I'm ready to call this one solved.

Thanks for the feedback.