Bar chart with inlaid data in bar?

I would expect to use a stacked bar chart. I would also expect that most of the work will be in the spreadsheet and not in the chart. I would expect data to look something like:

Please Login or Register  to view this content.

With column A as the horizontal axis data, and C and D as your two stacked bar data series, you can then format the two stacked bars with the colors you want. I suspect that the hardest part is figuring out the formulas to get the right information into C2 and D2.

I Not sure I even understand where you are implying to input what you have written.

I'm not sure it matters a lot where you put it in the spreadsheet. I would expect one would put this table someplace adjacent to the existing data. Since I cannot see where you have the original data stored in the spreadsheet, I cannot really answer where you should put this table. Also, the exact formulas that will go into this table will depend on how you have the current data stored, so I don't think I can be more specific on these formulas.

Perhaps if you upload a sample Excel file rather than a picture.