• 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

    Hui...

  • 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

Cicicmici

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,
 

Attachments

  • test.xlsx
    18.1 KB · Views: 3
In the attached in Sheet Sheet2 you can choose your month(s) in cell I1 (or in the chart top left).
 

Attachments

  • Chandoo45747test.xlsx
    33.6 KB · Views: 15
Back
Top