Column chart colors

Hi,

I have 2 column charts, generated from different data feeds, but from the same excel file (filtered differently).

My problem is with the stacked column's colors. The stacked columns show me the number of processes in each modeling status in every category. But, the colors for each status is different in the 2 charts (as you can see in the screen shots i've added below).

I want the legend to be the same for every chart. How do i do this?

Chart 1- notice that the status 'Approved' is orange

 Chart 2- notice that the status 'Approved' is now yellow 

Thanks,

Yaara