Hello forum,
I am not sure if I need VBA for this.
I have approx 40 line charts embedded into my workbook (1 for each workshheet)
Each line displays 56 points of data. (8 weeks data .. a point for each day)
I want to have a different colour backgraound for each two weeks data, therefore want the background divided into 4 colours.
Does anyone know how to do this?
cheers
Koala