Sorry for the late posting. I was in Atlanta all week working on a new project and going out with the client at night, so I had no time to finish this post. For the previous Friday Challenge, I posted this question:
Excel Dashboard Chart Design: There is no right answer here as everyone will see the solution differently. Send me your sample chart design and I will post a poll to see which Excel Chart that everyone likes best. Here is the question and data:
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 |
Well I received several AMAZING submissions. I won’t bias the poll results, but take a second to check out the video with a demonstration of each dashboard chart and if you want more, feel free to download the dashboard template files below.
1) Line Chart
2) Bar Chart
3) Stacked Column
4) Stacked Line Small to Large
5) Dynamic Excel Dashboard
6) In Cell Chart Bar Chart
7) Column Chart
8) Stacked Column Chart of Amount Changed
9) Stacked Area Large to Small
Please vote in the poll:
POLL – Friday Challenge Schedule Changes Over Time
After you have voted, check out the video that describes each of the submissions:
Here are the free Excel template download files:
File 1: Friday-Challenge-Charts-Schedule-Changes.xlsx
File 2: FridayChallengeDashboard.xlsm
File 3: Graph-Data.xlsx
File 4: Friday-Excel-Dashboard-Example.xlsx
Thanks so much to all my fans that submitted such awesome work. And is such a short period of time. You all rock!!!
Steve=True
I have a response to your August 30 Friday Challenge.
Thanks Mark. Awesome solution. Steve=True
I am not sure I understand the codes, but my chart is on the way.
Ours is not to reason why Don, ours is but to DO 🙂 Thanks for the comment 🙂 Looking forward to your chart.
I have a possible way to view the data. It is on its way to you. Let me know what you think.
-Pete