Consolidated Production chart (Production vs wastage vs Changeovers)

Dear Gurus/Sir,

I need help.. On a daily basis I've to share Plant progress Dashboard with my Management, where I've been also sharing daily production trend, where I plotted production on primary axis and on secondary axis daily wastage/spoilage is plotted... my Management has asked me to add number of changeovers in same chart which I'm unable to do as Production is reported in Million pieces, unit of wastage is in %age and daily changeovers (which are mainly label/color changeovers) from zero to 5 depending on confirm orders.

Please find the attached data in xls. Appreciate if someone kindly consolidate both in one chart.

Regards/ Abrar

See if this is what you had in mind.

Thanks ever so much ..... stay blessed

One additional change I forgot to make..
Have the Secondary Axis label the same color as the line(red).
Since you have three different axis' this helps the reader know what data goes with what axis.