Hi All,
Well it is Friday and I wanted to post another challenge. This chart challenge is more in the Excel Dashboard Design category. There is no right answer here as everyone will see it differently. Next week, I will post my answer on how I would design this chart. However, please send me your sample chart. Then I will post a poll to see which Excel Chart that everyone likes best at the end of next week. Read the question below and then copy the data to your own spreadsheet and then create your best Excel Dashboard Chart. Then don’t forget to send me your result. Good luck!
How would you chart/graph this data?
Situation: “I’m tracking the number of schedules changes but would like to show the reasons on a chart as well. What is the best approach to plot the number of schedule changes in a over the period of time in the attached? – John”
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Schedule Change Metric | Reason codes | ||||||||||
| 2 | Week | schedules | changes | % change | Quality | Vendor | Attainment | Ops | Planning | Consumption | R&D | Sales |
| 3 | 1 | 42 | 4 | 9.5% | 1 | 1 | 1 | 1 | ||||
| 4 | 2 | 58 | 7 | 12.1% | 2 | 4 | 1 | |||||
| 5 | 3 | 61 | 3 | 4.9% | 3 | |||||||
| 6 | 4 | 56 | 9 | 16.1% | 1 | 2 | 1 | 2 | 3 | |||
| 7 | 5 | 57 | 14 | 24.6% | 3 | 7 | 1 | 3 | ||||
| 8 | 6 | 55 | 10 | 18.2% | 5 | 4 | 1 | |||||
| 9 | 7 | 51 | 3 | 5.9% | 1 | 2 | ||||||
| 10 | 8 | 52 | 2 | 3.8% | 2 | |||||||
| 11 | 9 | 58 | 10 | 17.2% | 1 | 5 | 2 | 2 | ||||
| 12 | 10 | 47 | 3 | 6.4% | 3 | |||||||
| 13 | 11 | 48 | 1 | 2.1% | 1 | |||||||
| 14 | 12 | 45 | 2 | 4.4% | 1 | 1 | ||||||
| 15 | 13 | 28 | 1 | 3.6% | 1 | |||||||
| 16 | 14 | 42 | 7 | 16.7% | 3 | 1 | 3 | |||||
| 17 | 15 | 44 | 0 | 0.0% | ||||||||
| 18 | 16 | 41 | 1 | 2.4% | 1 | |||||||
| 19 | 17 | 41 | 0 | 0.0% | ||||||||
| 20 | 18 | 39 | 0 | 0.0% | ||||||||
| 21 | 19 | 38 | 1 | 2.6% | 1 | |||||||
| 22 | 20 | 46 | 1 | 2.2% | 1 | |||||||
| 23 | 21 | 38 | 0 | 0.0% | ||||||||
| 24 | 22 | 38 | 1 | 2.6% | 1 | |||||||
| 25 | 23 | 49 | 0 | 0.0% | ||||||||
| 26 | 24 | 34 | 2 | 5.9% | 2 | |||||||
| 27 | 25 | 33 | 3 | 9.1% | 3 | |||||||
| 28 | 26 | 32 | 6 | 18.8% | 5 | 1 | ||||||
| 29 | 27 | 18 | 0 | 0.0% | ||||||||
| 30 | 28 | 37 | 2 | 5.4% | 2 | |||||||
| 31 | 29 | 34 | 4 | 11.8% | 4 | |||||||
| 32 | 30 | 32 | 0 | 0.0% | ||||||||
| 33 | 31 | 31 | 1 | 3.2% | 1 | |||||||
| 34 | 32 | 33 | 5 | 15.2% | 5 | |||||||
| 35 | 33 | 33 | 1 | 3.0% | 1 | |||||||
| 36 | Totals | 1391 | 104 | 7.48% | 3 | 37 | 5 | 38 | 6 | 0 | 5 | 10 |
If you have a a design that you want to submit, please leave me a comment (there is a private space for your email address) and since my comments are moderated due to spam, I will see your response and send you an email so that you can send me your spreadsheet.
Steve=True
Reader discussion
Comments preserved from the original page. New comments are closed.
Mark Paradis
August 30, 2013 at 8:44 am
I have a response to your August 30 Friday Challenge.
admin
August 30, 2013 at 1:13 pm
Thanks Mark. Awesome solution. Steve=True
Don
August 30, 2013 at 1:55 pm
I am not sure I understand the codes, but my chart is on the way.
admin
August 30, 2013 at 2:22 pm
Ours is not to reason why Don, ours is but to DO
Thanks for the comment 
Looking forward to your chart.
Pete
August 30, 2013 at 3:10 pm
I have a possible way to view the data. It is on its way to you. Let me know what you think.
-Pete
admin
August 30, 2013 at 3:40 pm
Looking forward to it.