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!
Bookmarks