• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

week comparison chart


New Member
Hi Chandoo colleagues.

I attached a file, I am struggling with last days. I am working on week comparison chart. I have to compare week data , by day name, in given month. This chart should be with dynamic data, so I do not know in advance week number, starting days…This data I got with formulas.
The problem I am facing it, that my first week starts from Sunday, and in the last I have 2 days.
When I make line chart, my 1 and 6 week data do not correspond their days.

Is there any possible solution that I finish my task?

Thanks in advance,