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

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”

ABCDEFGHIJKL
1Schedule Change MetricReason codes
2Weekscheduleschanges% changeQualityVendorAttainmentOpsPlanningConsumptionR&DSales
314249.5%1111
4258712.1%241
536134.9%3
6456916.1%12123
75571424.6%3713
86551018.2%541
975135.9%12
1085223.8%2
119581017.2%1522
12104736.4%3
13114812.1%1
14124524.4%11
15132813.6%1
161442716.7%313
17154400.0%
18164112.4%1
19174100.0%
20183900.0%
21193812.6%1
22204612.2%1
23213800.0%
24223812.6%1
25234900.0%
26243425.9%2
27253339.1%3
282632618.8%51
29271800.0%
30283725.4%2
312934411.8%4
32303200.0%
33313113.2%1
343233515.2%5
35333313.0%1
36Totals13911047.48%33753860510

 





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

LEAVE A REPLY

Please enter your comment!
Please enter your name here