• 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.

Comparing chart by weekdays

madocar

madocar

Member
Hello everyone,


I would like to ask you to help me. The thing is that I want to compare last two weeks by weekdays. It means I want to compare some values as monday to monday, tuesday to tuesday in "Line with markers chart". So basically having 7 columns is the best option.

I don't know how to make "monday" as a specific parameter that has 2 values

Perhaps It would be better to upload the file here but it is not possible right?


Thanks
 
Madocar

Setup two ranges 1 for this week and 1 for last week

I'd suggest using a standard Clustered Column Chart


Files can be uploaded by reading the Green Sticky posts at:

http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi ,


I have made an example file implementing Hui's suggestion ; see if it is what you want :


https://www.dropbox.com/s/xzhrwfw6d03vvgt/Madocar_Example.xlsx


Narayan
 
You must log in or register to reply here.
Back
Top