Edit to "colour to chart" macro - to cycle through workbook

[p45cal]

but it's almost like it is not recognising the dates in the associated cells?

Can you be more specific? What's not happenning that should be?