Stacked bar chart in my report (1 Viewer)

I am using Access 2007-2010 and I was able to create a report but now I want to include a stacked bar in it.

My report shows one record at a time, so the values for my chart change accordingly. The chart should have four columns: Student, Homemaker, Retired, Employed I have assigned a colour for each category in "Edit" mode (by clicking separately on each column). However, sometimes the results don't show all four values and then my stacked chart only has 3 categories, but I would like it to show the missing category and just have value as 0. But most importanly the colours get all messed up. Can I permanently assign a color for each column?

Also the order is not how I want it to show. Right now it's in alpha order..how can i customize the order of the columns?
I tried doing this in datasheet - saved; but when I switch to a report view - everything changes back

Post a stripped version of your database with some sample data + a print screen/ picture how you want it shown.