Graph to display past dates in one colour and remaining dates in other colour

Hi,

Need help on putting different colours to past dates and today to weekend / monthend in different colour.

An excel file attched with necessary details.

Pl. help.

Thanks,
Nagesh.

I have a solution for the week graph by day. but not for the chart by week. I do not get the adjusted weeknumbers where week 1 is 10 days and week 4 only 4 days. does every month start with week 1? is week 1 always the longer week?

For the Blue and green graph per day I used 2 series.
and a forced error in the if formula helps to hide unwanted data points.
in the Graph settings you set to leave #NA errors blank on the graph.

check the file for details.

Thats great @Joel Jangman.

Thanks.

As far as week is concerned, we distribute in to 4 weeks (1 or 2 plus, say in April, date 1 starts on Friday and the month is shared by 5 weeks. In order to make a 4 weeks, 1st and 2nd included in week one. Similarly if a month ends say Monday or Tuesday, the extra 1 or 2 days will be added in to last week. Otherwise graph will show 5 weeks and first or last week will show as poor performing week (since the working days are less). Hence if the formula is set as per the week numbers given as per column D, then there will always be 4 weeks and the working days can be adjusted in 1st or last week.

Hope it is clear now.

Grateful if you can show a way out on the weeks graph too.

Anyhow thanks once again.