Dynamic charts with a week view comparison

[yourskarthik1983]

Hello Friends,

I am preparing report in which data is collected at different time intervals (say every 2 hrs) every day.

I have prepared a clustered column chart to show each day. What I need is to show the graphs in a week view (by enabling check box).. I have done the check box but is there any way to find the week of the month from the date??

I need this because, i have to compare weekly data and MTD.. I have attached the spreadsheet for your reference..

Appreciate your help on this..

[pike]

hi yourskarthik1983
you could use a pivotchart