Friday Excel Challenge Submissions–Which Chart Solution One Do You Like Best?

By
admin

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 Chartimage
2) Bar Chartimage
3) Stacked Columnimage
4) Stacked Line Small to Largeimage
5) Dynamic Excel Dashboardimage
6) In Cell Chart Bar Chartimage
7) Column Chartimage

8) Stacked Column Chart of Amount Changedimage
9) Stacked Area Large to Smallimage

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





5 COMMENTS




  3. If you found the website and tutorials helpful, please consider donating to keep the lights on.

    Donate with PayPal here:




LEAVE A REPLY

Please enter your comment!
Please enter your name here