I need a chart that has

Collections
Charges
Units

For 3 years

Broken out by payor mix.

I have tried to do the stacked chart thinking y axis would have dollars, x
axis would have years 1-3 and then for each year I would have 3 bars (each
stacked by payor) for collections, charges and units.

I can get this to run but only for one year. I cannot get 3 bars per year.

I am certain it is something to do with the way I have highlighting the data
range and or the series. We have worked all weekend getting the data and now
cannot determine how to run chart.

Please help!