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

Chart Suggestion Chart YOY & MOM

A11 Mighty

Member
Hi All,

Appreciate any suggestions to present the attached sample data in to a few chart. The details below are just what I have in mind and I am open to any suggestion.
Sheet 1 :
Comparison of YOY
  • 2020 VS 2021 VS 2022 year to date
  • Count of parts
  • Sum of orders
Comparison of Month over Month
  • Jan 2020 VS Jan 2021 VS Jan 2022 ( as an example)
  • Count of parts
  • Sum of orders
Percentage of change
See chart sample I found online included in Sheet 1 and 2

Sheet 2 :
Would like to measure the associates performance:
Comparison of :
  • 2020 VS 2021 VS 2022 year to date
  • Total tasks
  • Total Items
Comparison of Month over Month
  • Jan 2020 VS Jan 2021 VS Jan 2022 ( as an example)
  • Total tasks
  • Total Items
Percentage of change
See chart sample I found online included in Sheet 1 and 2

Thanks in advance for your help!

A11 Mighty
 

Attachments

  • Chandoo Chart.xlsx
    40.7 KB · Views: 5
Back
Top