Sales Analysis Charts in Excel – 78 Alternatives

32 Responses to “Sales Analysis Charts in Excel – 78 Alternatives”

1. Daniel Ferry says:

   June 30, 2011 at 9:31 am

   Great contest, Chandoo.

   I wish that I had had time to enter! Looking forward to see which was the winner...

   Reply
2. Nuno Oliveira says:

   June 30, 2011 at 9:42 am

   Hi,
   First of all, congratulations to all participants 🙂
   I personally choose between the following graphs: 8, 15, 17, 22, 31, 40, 41
   My firts choise goes to: 31

   Well done for all! 🙂

   Reply
3. Marcelo says:

   June 30, 2011 at 11:54 am

   Who's the winner? The readers!
   Great stuff guys, lots of knowledge displayed, lot to learn!

   Reply
4. martin says:

   June 30, 2011 at 3:24 pm

   what a great contest.
   pity that I'm just learning how to visualize data, I didn't participate.
   also it's pity, that some of actually beautiful charts we cannot download for study.
   my personal winner is Ezequiel [12]. Via his chart I've got picture about profitability most easily and additional pro is, that he share his ideas with us.
   this whole web site is really a well of knowledge.
   good job Chandoo.

   Reply
5. Alan says:

   June 30, 2011 at 4:01 pm

   Thanks Chandoo! There are some really nice ones in there!

   Reply
6. P Sethi says:

   June 30, 2011 at 4:45 pm

   My favourites: 8,15 n 31

   [8] second last visualization answers a lot of questions at one go
   eg effect of monthly price changes in value /volume, which are not answered by 15 and 31.

   Design wise - 31 wins hands down ! Revenue wheel by 15 is quite interesting

   Reply
7. Fred says:

   June 30, 2011 at 5:06 pm

   Thanks Chandoo. I enjoy doing this contest and I know I'm going to have a field day downloading and learning from all the bright minds here.

   Just wondering from business stand point (not excel technique) which one would you rate best in giving you insight on managing your business in the future? That's what I have learn on the jobs serving a cruise-load of managers, GM, VP, C-executives. They want me to deliver something that not just tell a story (about the past), but tell them what lies ahead (the future).

   More contests please!

   Reply
8. Fred says:

   June 30, 2011 at 5:18 pm

   I can't download the third file of chart 04.

   Reply
9. m-b says:

   June 30, 2011 at 5:28 pm

   Ah, I didn't get picked 🙁

   Nice to see all the other attempts though, always interesting to get new ideas and learn new things 🙂

   Reply
10. Fred says:

    June 30, 2011 at 6:12 pm

    I was studying Solution 3 of chart 15. And here is an observation.

    The -19% change was the difference between the Per Unit Revenue in May vs. Average Per Unit Revenue (Jan-May), not necessarily a reduction in "overhead cost". The wording should have been a reduction in dashboard tutorial #1 in May could have been due to an INCREASE of per unit revenue by 19%.

    In fact, using the existing definition the denominator should be -16% because it should have been ( May Per Unit Rev - Avg Per Unit Rev ) / Avg Per Unit Rev. The formula used in the worksheet is ( Avg Per Unit Rev - May Per Unit Rev ) / Avg Per Unit Rev.

    Reply
11. Nadeem (Meedan) says:

    July 1, 2011 at 5:00 am

    Hi Chandoo,

    First of all, I truly appreciate your time and effort. You are doing an awesome job. Hats off to you & your team.
    I have bookmarked this post & will really learn a lot with all these charts. Thank you so much.

    Chandoo & Hui - Also, Thanks for liking my chart - 31.

    Reply
12. Ameya says:

    July 1, 2011 at 7:50 am

    Hi Chandoo,

    Thanks for featuring my chart... learnt a lot just by entering into the contest .......... i had asked you a question in the submission mail .... would appreciate if you could take out some time to answer.......thanks

    Reply
13. Winners of the Sales Analysis Chart Contest + One more Giveaway | Chandoo.org - Learn Microsoft Excel Online says:

    July 1, 2011 at 8:50 am

    [...] we saw the entries for the sales analysis chart contest. Today, we will find who the winner [...]

    Reply
14. venkatesh says:

    July 1, 2011 at 5:25 pm

    i will accept the fact that i am going crazy... looking at these charts... you will not believe, that how much i gained (and at times effortlessly....by using the charts you all posted).... Using creativity and inputs from you all, i would like to post that i am earning goodwill at office. and i am proud to say, i DO COPY from this site.... But let me assure you, that i do use my creativity too.... thanks all for such wonderful posts... And NO WORDS to thank Chandoo for his site and selections............. what can i say... JUST HATS OFF !!

    Reply
15. dabaskar says:

    July 2, 2011 at 6:05 pm

    hi chandoo,
    Wht a gr8 contest. i most like chart no 15 and 25. good effort by all.

    Reply
16. Jayant SB says:

    July 4, 2011 at 7:52 am

    Hi Chandoo,

    First of all thanks for spreading the knowledge of the best tool 'Excell'. though we have veri sofiticated applications available in the market, this Excell is the best and quickest tool to learn and use. Thanks to all participants and congrates to winner as their presentation is really readable.

    I expect more challanges more compitition going forward...

    ' We are the world ...... its Excell World'

    Good luck !

    Jayant SB

    Reply
17. hoomantt says:

    July 7, 2011 at 8:58 pm

    i love you chandoo .
    love you professor.chandoo

    Reply
18. You Be The Judge in This Excel Dashboard Contest | The Dashboard Spy says:

    July 13, 2011 at 5:05 am

    [...] I’d give you a little fun and play “Excel Chart Judge”. Take a look at the 78 Excel Chart Alternatives and decide which ones are the best. Then go to the blog post where Chandoo picked the winners: [...]

    Reply
19. You Be The Judge in This Excel Dashboard Contest « Marketers.BlogNotions - Thoughts from Industry Experts says:

    July 18, 2011 at 5:10 am

    [...] I’d give you a little fun and play “Excel Chart Judge”. Take a look at the 78 Excel Chart Alternatives and decide which ones are the best. Then go to the blog post where Chandoo picked the winners: [...]

    Reply
20. Minocher Buhariwalla says:

    August 12, 2011 at 10:44 pm

    Dear Chandoo ! Excellent social service and participation built into a successful business model. Wishing you greater success !!!

    Reply
21. KC hello says:

    October 6, 2011 at 8:11 am

    I have to say I was most impressed by "[29] Column chart by Michael." Specifically the part where the item selected is signaled by an arrow/triangle in the chart itself. I would love to know how that is done.

    Reply
22. Murali says:

    November 12, 2011 at 7:46 am

    CAn u send me the e-book of charting

    Reply
23. Learn Any Area of Excel using these 80 Links | Chandoo.org - Learn Microsoft Excel Online says:

    December 12, 2011 at 9:02 am

    [...] Sales Analysis Charts & Dashboards in Excel [...]

    Reply
24. Dennis says:

    January 14, 2012 at 10:05 pm

    WOW, what an incredible charts! Learnt a lot from it, thank you all for that!

    From Chart 31 I understand most of it, except the RED SPIN BOX (above cell A29).

    I cannot move it and I cannot right click on it.

    Does anybody know how I can re-create this red spin box?
    Also is it a spin button or something else? (in form controls I cannot seem to make a horizontal spin button).

    Reply
25. Mark says:

    January 16, 2012 at 6:19 pm

    What a great contest! I have picked up so much from you all! Thanks for the posts. I really liked #15 and #22. I like the circle idea to use for showing overall handle time and the breakdown by certain call types that make up the handle time. #22 also will help show the same data, but on a monthly time line. Most of the charting I do ends up in a paper presentation so I do not get to use the interactive charts.

    Reply
26. Ammara says:

    January 31, 2012 at 12:36 pm

    hello. i just want to know that how to combine multiple charts in one area for panel charts???????

    Reply
27. Deepak says:

    March 1, 2012 at 1:46 am

    Thanks for the awesome posting and providing an opportunity to learn

    Reply
28. Jevi says:

    March 7, 2012 at 9:38 am

    I like chart 31..great and is close to what I do but it sound is not easy to create it or change as a like the red spin buttonn...! I think there is a macro. It would be really great if we could have also the explanation Nadeem for the dumpies :pp! I have been trying to do the same but no result till now.

    Congratulations to all...great job :).

    Reply
29. CE#524: Sales Analysis Charts in Excel – 78 Alternatives (Chandoo.org) « Conocimiento Estratégico says:

    March 10, 2012 at 3:33 am

    [...] Full article here Like this:LikeBe the first to like this post. [...]

    Reply
30. German Perey says:

    March 21, 2012 at 8:27 pm

    Excelente los gráficos... Se agradece que los compartas

    Reply
31. Rhevie says:

    January 31, 2016 at 10:00 am

    Hi Chandoo,

    1. How to create interactive map on dashboard?
    2. How to change color state on the USA map based on the data trigger?

    NB: without macro or VBA

    Thank you

    Reply
32. Alfred Demko says:

    June 15, 2017 at 7:59 am

    Merely a smiling visitant here to share the love (:, btw outstanding style. "Treat the other man's faith gently it is all he has to believe with." by Athenus.

    Reply

Leave a Reply