Multiple Stacked Columns?

[Scubaru]

I created a fake dataset of something I am trying to work on with private information but the concept of what I want to achieve is the same.

I am working on a scrap report, we document scrap in two ways, under XXX quantity is just per piece scrap. Above XXX amount we get a credit for defected items. This data set below shows two groups of data tracked by month and with the same defects. I also show total quantity of that item ordered. What I want to do is have for say January two vertical columns, one for the first data set and the other for the second data set. I would have to use two vertical axis since the larger numbers on the second dataset will shrink the stacked columns. Is there anyway to achieve this? I have included in my demo graph a line graph that charts total purchased items to see if the defects trend with the total orders, I cant imagine I can overlay a line graph like this as well?

Demo Data.JPG

Demo Chart.JPG

[MrShorty]

a column + line seems to be a common example in tutorials for creating combination charts in Excel:
https://support.office.com/en-us/art...F-DA021177452F
https://www.excel-easy.com/examples/...ion-chart.html
The only real difference in your case is that yours is a stacked column instead of a clustered column. Let us know if you need more help to put this combo chart together.

[NickyC]

hi
is this what you're after?