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

Show Variance week by week

Rehabguru

New Member
Dear Excel Ninjas

I would love to have your help with the following problem.

I have 12 sites reporting a number of contacts once a week. How can I show these differences, or the variance each week between the dates, for each site? Ideally I would display the data as a waterfall graph, with the ability to choose the current week compared to the previous week. Any help or ideas would be greatly appreciated.

Thank you in anticipation ;)

Rehabguru
 

Attachments

  • Sample data for variance.xlsx
    9 KB · Views: 2
Maybe a column chart is already doing what you want?
68300
 

Attachments

  • Copy of Sample data for variance.xlsx
    16.5 KB · Views: 0
Back
Top