Can you post a workbook? What is the problem with the second solution? From where you are, all you need to do is Right Click on the Right Axis and choose "Move Marks to Front", then edit the colors to be the colors that you want to use.
Then you could also go to Analysis > Stack Marks to un-stack the marks and do a Bar in Bar chart to replace the Bar Chart.
Thanks for the quick response.I want those stacked side by side with the line graph, not one on the other. I tried what you told, but didn't work for me.
"do a Bar in Bar chart to replace the Bar Chart." I didn't get this.
Can't post the workbook.
Thanks for that! I'll take a look at it.