Excel 2007 : same variables monthly - want the bars color coded for each

[Sam Capricci]

I have the same 4 variables each month: assisted, found, witnessed and reported.
In my 2D bar chart they are all the same color. I want them to be consistently colored each month but different from each other.

[dip11]

You need to have a separate series for each of the 4 variables. They are the same color because they are 1 series.

[Sam Capricci]

thank you. I broke apart the dates from the variables and it now works.