Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations

Posted on January 4th, 2010 in Charts and Graphs , Featured - 84 comments

Sales Dashboards - 32 Examples, Vote for your option now [Visualization Challenge #2]Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in November, I have asked you to visualize sales data using sample data. The visualization challenge #2, sponsored by Zoho Reports generated a huge buzz around the community and fetched 32 incredible entries. The response was so overwhelming that it took me almost 24 hours to write this post.

Thanks everyone for participating and making this a huge learning experience for everyone. Personally I have learned several useful dashboard and charting tricks. I will be sharing some of these lessons with all of you in the coming weeks.

How read this post?
This post is HUGE, I mean 2600 words huge. So you may want to maximize your browser window and fill up your coffee mug. Each of the 32 entries start with a title including authors name and tools used. Each entry includes a small image of the dashboard along with a link to see bigger version. All dashboards have links to original source files for you to download and play with.

Please note that these files are copyrighted to original authors and you cannot use them for commercial purposes.

I have included 3 comments against each entry based on my understanding of dashboard. Please share your opinions and reviews using the comments section of this post.

Javascript based Sales Dashboard by Ahmad (Option 01)

Javascript based Sales Dashboard by Ahmad
larger version
My Comments:

  • Dynamic dashboard, lets user choose the dimensions of data and shows sales performance immediately.
  • Easy to compare performance of various criteria, can get too cluttered if you add several dimensions.
  • Uses Javascript, thus runs in most web browsers

Download Source Files: Link 1 | Link 2

Excel based Sales Dashboard by Aires (Option 02)

Excel based Sales Dashboard by Aires
larger version
My Comments:

  • Shows analysis of “selected month” along with next 23 months.
  • Includes a tweetboard for easy interpretation and key messages.
  • Shows the growth rate of sales (derived metric)

Download Source Files: Link 1

Excel based Sales Dashboard by Ajay (Option 03)

Excel based Sales Dashboard by Ajay
larger version
My Comments:

  • Analysis of sales data by “sales person” shown very clearly.
  • Aesthetically pleasing design, fewer colors and options to reduce confusion. Good use of sparklines.
  • Stacked charts could use some improvement as they are difficult to read or compare.

Download Source Files: Link 1 | Link 2 [Ajay's website]

Excel based Sales Dashboard by Alex Kerin (Option 04)

Excel based Sales Dashboard by Alex Kerin
larger version
My Comments:

  • Very good use of incell charts and sparklines (addin from Fabrice).
  • Shows derived metrics like 3 months rolling sales. Also, uses a real map to show region-wise performance.
  • Good use of tables with conditional formatting (also, headlines clearly call for attention).

Download Source Files: Link 1 | Link 2 | Link 3 [Alex Kerin's website]

Excel based Sales Dashboard by Arti (Option 05)

Excel based Sales Dashboard by Arti
larger version
My Comments:

  • Dynamic dashboard, lets you compare sales by customer type or region or sales person. Also, compares values with averages.
  • Good mix of charts for selected data along with big-picture. Also, includes clear headlines and messages (like “2008 sales person of the year is Chewbacca”).
  • Fewer colors and objects, easy to read the dashboard.

Download Source Files: Link 1 | Link 2 [Arti's website]

Excel Dashboard Training by Chandoo.org

Excel Dashboard Training
My Comments:

  • Learn how to make Excel Dashboards using this 1 hour training video
  • Instantly download video, excel workbooks, bonus material.

Click here to try Excel Dashboard Training

Excel based Sales Dashboard by Cole Burdette (Option 06)

Excel based Sales Dashboard by Cole Burdette
larger version
My Comments:

  • Lets you compare one combination of sales data like Sales in North region for product light sabres to the customer “galaxy” by sales person “hansolo” with all other possible values.
  • Fewer charts thus easy to read without getting lost.
  • Could use some formatting better color choices. Also, shows only trends, not much on current month’s data.

Download Source Files: Link 1

Excel-Palo based Sales Dashboard by Cuboo (Option 07)

Excel-Palo based Sales Dashboard by Cuboo
larger version
My Comments:

  • Dynamic dashboard with option to select month and sales person. Shows historic data for last 12 months.
  • Clever use of incell sparklines and bullet charts to show performance of product by sales person.
  • Includes clear comments (headlines). Fewer objects, so easy to read. Also, has data labels and other chart elements to help us read the findings.

Download Source Files: Link 1 [Cuboo's website]

Excel based Sales Dashboard by Duezzz (Option 08)

Excel based Sales Dashboard by Duezzz
larger version
My Comments:

  • Shows overall sales trend along with 2009 summary
  • Analysis by customer type and product.
  • Uses pie charts to show product composition in sales.

Download Source Files: Link 1

Jmp based Sales Dashboard by Erin Vang (Option 09)

Jmp based Sales Dashboard by Erin Vang
larger version
My Comments:

  • Very rich dashboard presentation – thanks to JMP. Shows trends using panel charts (of lines).
  • Includes 3 summary charts to prove points (like Luke sells more than others etc.)
  • Interesting treemap style of visualization.

Download Source Files: Link 1 | Link 2 | Link 3 | Link 4 [Erin Vang's website]

Excel based Sales Dashboard by Esteban (Option 10)

Excel based Sales Dashboard by Esteban
larger version
My Comments:

  • Very good placement of charts – uses the natural positions of regions (north, east, south and west)
  • Cleve use of incell charts (using REPT formula)
  • Dynamic dashboard – user can select one of the products.

Download Source Files: Link 1 | Link 2

Excel based Sales Dashboard by Hernan (Option 11)

Excel based Sales Dashboard by Hernan
larger version
My Comments:

  • Clear layout with charts at yearly level and qtrly level. Fewer colors and easy to read.
  • Includes headlines (key messages) by sales person. Very useful to understand the performance of sales persons.
  • Provides analysis only from sales person point of view.

Download Source Files: Link 1

Excel based Sales Dashboard by Karimmo (Option 12)

Excel based Sales Dashboard by Karimmo
larger version
My Comments:

  • Dynamic dashboard with option to select dimension and metrics along with time frame for reporting.
  • Shows overall distribution along with chart for selected option. Easy to compare how the selection is doing wrt others.
  • Could use some more charts.

Download Source Files: Link 1 | Link 2 | Link 3

Excel based Sales Dashboard by Karimmo (Option 13)

Excel based Sales Dashboard by Karimmo
larger version
My Comments:

  • Dynamic dashboard with option to select dimension and metrics along with time frame for reporting.
  • Has additional filtering options.
  • Could use some more charts.

Download Source Files: Link 1 | Link 2 | Link 3

Excel based Sales Dashboard by Karimmo (Option 14)

Excel based Sales Dashboard by Karimmo
larger version
My Comments:

  • Dynamic dashboard with option to select dimension and metrics along with time frame for reporting.
  • Has additional filtering options.
  • Could use some more charts.

Download Source Files: Link 1

Excel based Sales Dashboard by Karimmo (Option 15)

Excel based Sales Dashboard by Karimmo
larger version
My Comments:

  • Dynamic dashboard with option to select dimension and metrics along with time frame for reporting.
  • Has additional filtering options and shows additional charts on demand. Provides instant comparison of selected option against other data.
  • Very cleaver use of form controls.

Download Source Files: Link 1 | Link 2 | Link 3

Excel based Sales Dashboard by Karimmo (Option 16)

Excel based Sales Dashboard by Karimmo
larger version
My Comments:

  • Dynamic dashboard with option to select dimension and metrics along with time frame for reporting.
  • Has additional filtering options and shows additional charts on demand. Provides instant comparison of selected option against other data.
  • Very cleaver use of form controls.

Download Source Files: Link 1

Excel based Sales Dashboard by Leandro (Option 17)

Excel based Sales Dashboard by Leandro
larger version
My Comments:

  • Very good use of pivot charts to make dynamic chart
  • One chart to rule them all.
  • Could use some variety and trickery.

Download Source Files: Link 1 [Leandro on twitter]

Excel based Sales Dashboard by Lee (Option 18)

Excel based Sales Dashboard by Lee
larger version
My Comments:

  • Simple and intuitive dashboard design. Fewer colors and better formatting. Very easy to read.
  • Includes average lines to provide instant comparison.
  • Could include some messages so that it is easy to scan the report to establish them.

Download Source Files: Link 1

Excelcius based Sales Dashboard by Mahesh (Option 19)

Excelcius based Sales Dashboard by Mahesh
larger version
My Comments:

  • Uses Excelcius to show chart by selected options.
  • Simple chart options, easy to read and understand.
  • Could use some more charts.

Download Source Files: Link 1

Excel based Sales Dashboard by Mahesh (Option 20)

Excel based Sales Dashboard by Mahesh
larger version
My Comments:

  • Uses Excel to show chart by selected options.
  • Simple chart options, easy to read and understand.
  • Could use some more charts.

Download Source Files: Link 1

Excel based Sales Dashboard by Mahesh (Option 21)

Excel based Sales Dashboard by Mahesh
larger version
My Comments:

  • Dynamic dashboard with ability to select a sales person to see their performance.
  • Uses combo charts to show sales along with growth rates.
  • Could use better formatting and chart choices

Download Source Files: Link 1

Excel based Sales Dashboard by Martin (Option 22)

Excel based Sales Dashboard by Martin
larger version
My Comments:

  • Simple design with dynamic charts. Very good use of form controls and pivot charts to show data based on user selection.
  • Very easily provides analysis on how sales person are doing in regions etc.
  • Could include some messages.

Download Source Files: Link 1

Excel based Sales Dashboard by Matt Cloves (Option 23)

Excel based Sales Dashboard by Matt Cloves
larger version
My Comments:

  • Clever use of form controls. Very elegant design with clear colors and fewer charts.
  • Good implementation of panel charts with ability to rotate so that comparison is easy.
  • Focus on analysis from sales person point of view with overall trends and key messages. Very good design.

Download Source Files: Link 1

Excel based Sales Dashboard by Miguel (Option 24)

Excel based Sales Dashboard by Miguel
larger version
My Comments:

  • Very intricate design with ability to select date ranges, dynamic filters and powerful drill-down of data.
  • Tables show performance of sales persons clearly while key KPIs are highlighted.
  • Fewer colors and charts. Easy to read and compare without loosing attention.

Download Source Files: Link 1

Excel based Sales Dashboard by Nick (Option 25)

Excel based Sales Dashboard by Nick
larger version
My Comments:

  • Cleaver use of pivot tables and pivot charts.
  • Relies on excel pivot features to provide required dynamic filtering of data.
  • Pivot charts can be cluttered when all filters are reset.

Download Source Files: Link 1

Project Management Dashboards (recommended product)

Project Management Templates for Excel
My Comments:

  • Using My Excel Project Management Templates you can make dynamic project status dashboards from your data in few minutes.
  • These templates make you better at project management and reporting.

Click here to try Excel Project Management Templates

Excel based Sales Dashboard by Pawel (Option 26)

Excel based Sales Dashboard by Pawel
larger version
My Comments:

  • Fewer colors and charts, elegant design with ability to filter based on region, product or customer. Also has the ability to select a date range to generate charts.
  • Answers 2 key questions: (1) how are sales persons doing based on selected criteria (2) How are sales persons doing for the entire timeframe on selected criteria.
  • Could include some messages.

Download Source Files: Link 1

Excel based Sales Dashboard by Pompadour (Option 27)

Excel based Sales Dashboard by Pompadour
larger version
My Comments:

  • Only 2 colors and just one chart type (lines on a panel chart).
  • Provides comparison by region, product and customer type very easily.
  • Could include some messages.

Download Source Files: Link 1 [Pompadour's website]

Excel based Sales Dashboard by Stephane (Option 28)

Excel based Sales Dashboard by Stephane
larger version
My Comments:

  • Dynamic dashboard with ability to select region, customer and product.
  • Uses tables and conditional formatting provide key data. Includes derived metrics like qtrly performance, comparison with previous year etc.
  • Has only one chart to show overall sales person trend for the selected options.

Download Source Files: Link 1 | Link 2 [Stephane's website]

Flot-Jquery-Ajax based Sales Dashboard by Steven Ng (Option 29)

Flot-Jquery-Ajax based Sales Dashboard by Steven Ng
larger version
My Comments:

  • Uses AJAX and Flot to generate the dashboard. Fewer objects and colors, so very easy to understand.
  • Includes key messages (like rankings of regions, products etc. totals)
  • Includes a dynamic chart to select sales person, region, product and customer. Also compares the selection against baseline (total sales by month etc.)

Download Source Files: Link 1 | Link 2 | Link 3 | Link 4 [Steven Ng's website]

Excel based Sales Dashboard by Tessaes (Option 30)

Excel based Sales Dashboard by Tessaes
larger version
My Comments:

  • Fewer colors (just 2) and clever use of line charts. Includes key messages and data tables to compare values against each other.
  • Dynamic chart to show the performance of selected dimension by various filters like region, sales person, product or customer.
  • The top and bottom performers table is very interesting. Cleaver design with attention grabbing colors.

Download Source Files: Link 1 | Link 2

Tableau based Sales Dashboard by Edouard (Option 31)

Tableau based Sales Dashboard by Edouard
larger version
My Comments:

  • Uses Tableau to generate a sales dashboard (requires tableau reader if you want to view this)
  • Includes filters to choose date range, products, customers, regions and sales person. Includes several heatmaps to compare values instantly.
  • Some charts can be improved (for eg. Growth by sales person has year 2008 with blanks, this is not required) Also heatmaps take sometime to understand.

Download Source Files: Link 1

Excel based Sales Dashboard by Faseeh (Option 32)

Excel based Sales Dashboard by Faseeh
larger version
My Comments:

  • Uses excel pivot charts to show product, customer type and region-wise sales by sales person.
  • Reader can easily filter values wanted using pivot features.
  • Could use some more charts and messages.

Download Source Files: Link 1

Excel Dashboard Toolkit (recommended product)

Excel Dashboard Kit
My Comments:

  • Using Charley’s Excel Dashboard kit you can quickly and easily make excel dashboards from your data.
  • I have personally tested and used this product and I find it extremely simple to use and can boost your productivity.

Click here to try Excel Dashboard Kit

Tutorials & Examples to Make Excel Dashboards

Thank you everyone

Thanks everyone once again for participating. All these entries are truly world class. Such beautiful display of skill. Thank you so much for teaching me how to make better dashboards.

Are you ready for Excel Automation? - Get Free Trial of ApeSoft

Your email address is safe with us. Our policies

84 Responses to “Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations”

  1. Andy Wall says:

    Chandoo

    Good to see the variety of styles of sales reporting. Too bad I missed this contest, will there be another?

  2. Jon Peltier says:

    Lots of variety.

    Many of these examples show only one chart, which hardly constitutes a dashboard. Many of the charts are bar charts, where line charts (i.e., time series) might have been more appropriate or more readable. Some of the color schemes are distracting.

    Yet there were a few good examples: Alex, Ajay, Cuboo, Tessaes.

  3. Chris Grant says:

    Wow, this is great. And — source files too! Thank you for organizing this.

  4. Karimmo says:

    Jon,
    The aim was not to build exclusively dashboards but: “all you have to do is a make one chart (dashboards are ok too) to visualize this sales data effectively”.

    Chandoo,
    I didn’t realize you will post every intermediate step of my chart :-) Option 16 (final version of my chart) misses the source file: http://bit.ly/8HwVSm

  5. Doozerboy says:

    Some very good dashboards here.

    Particularly like the funky rotate on Matt Cloves’ example, and Ajay’s example looks pretty pro too.

  6. m-b says:

    Isn’t it better to consider entries 12-16 as one entry? The same goes for 19-20.

    I think Cuboo is my favourite at the moment but I need to examine them more closely :)

  7. ericlind says:

    I’m partial to chart 5. I get enough information from the visuals to give me a suitable overview, and then I’m given clear consciece analysis on specific metrics.

  8. Jon Peltier says:

    Karimmo -

    Sorry, the post was entitled “Sales Dashboards”, so I made the natural assumption.

  9. TonyP17 says:

    Some amazing dashboards and clever methods of making the data dynamic.

    In many of the examples the methods used only become clear once hidden working sheets are displayed.

  10. chrisham says:

    Chandoo, thanks for putting this together, looking at the content here I am glad that I did not submit mine….. lol. But there’s a lot to be learning here in the coming days and may be the next time around I’ll be ready for it! Thanks so much for the source files… and of course to the contributors!

  11. Chandoo says:

    @Andy.. thanks, Yes, there will be more contests. I will announce one when we reach the 10k subscriber base. I am also open for new contest ideas and sponsors.

    @Jon: I named all the entries as dashboards out of convenience. Agreed that some of them are just charts (or pivot charts).

    @Chris: You are welcome.

    @Karimmo: I have considered each of your submissions as separate entries (my bad). I can add up the votes, but it might give you unfair advantage ;)

    @Doozerboy: Even I liked Matt’s rotate option. Watch out for a tutorial on that very soon :)

    @m-b: Good point, I have considered them as separate entries as it wasnt clear if the authors made multiple or single entries. Sorry for the confusion.

    Also, agree with you on Cuboo’s entry. As always very well done.

    @ericlind, Tony: Thanks

    @Chrisham: You should have tried. Next time, you must submit one.

  12. Oliver Montero says:

    Excellent work from almost all the contestants. Loved many and I’m eager to try some of the designs and to participate in the next contest. I specially liked options 26, 22, 03, 05 and 11. Very professional, clean and bug free. Too bad one can’t vote for more than one :(

    Thanks to Chandoo for doing this contest and to all participants. Looking forward for more iterations.

    Great stuff!!!!

  13. Alex Kerin says:

    Excellent work putting all of this together Chandoo, – hours of work I would guess. Some really good examples here. Thank you.

    One thing to think about when voting is that the original remit was to design a visualization for a “senior manager [to] understand how the sales people have done in the 24 months”. I’m certainly not saying this because I feel that my example is any better then others, more that so often in our field the resulting visualization does not fulfill the original objective.

    Breaking this down – a ‘senior’ manager does not have time, or want to dive into data exploration. He or she wants quick, easy to see, immediate answers on the most important questions with more data to help explain trends and allow decisions to be made.

    Equally, the visualization should primarily display “how the sales people have done”, so the chart(s) should be all be sales person centric. Questions like: “who performed best, against their expected performance, who sold what, who sold it where, what size companies did they sell to?” are likely wanted and useful. Finally, “24 months” implies the requirement for time trending information.

    Again, please don’t read this as any push for votes, simply that these excellent examples are assessed by their ability to meet the objective.

  14. TonyP17 says:

    I have downloaded the zip file link to Alex Kerin’s dashboard (Option 04) but do not know how to look at the numerous files contained within.

    Perhaps someone can explain please.

  15. Alex Kerin says:

    @Tony. The first link is the Excel file. The second is a link to the free (excellent) sparkline add-in I used. You don’t need to load it, but you may get some #NAME errors, and some cells won’t update if you change the data.

    If you do want to load it, select the correct version from the linked page (there are basically two – 2003 and before, and 2007). Load these up by opening them in Excel, allowing any macros if prompted, then open Link 1.

    Hence the problem with third-party add-ins – Office 2010 has its own sparklines, but this add-in is still much better…

  16. Jon Peltier says:

    Alex -

    Depending on how “senior” this executive is, I don’t think you used enough pie charts.

    Seriously, I agree with your comment. A dashboard is nice if it’s interactive, but it’s useless if it doesn’t show a broad overview of information in a single view.

  17. TonyP17 says:

    Alex
    The first link gives me a zip file to download. I do not see an Excel file to open other than several .xml files. Can you give me any further guidance please.

    Clearly there is plenty here I am not familiar with.

  18. Chandoo says:

    @Oliver: I am happy you liked it.

    @Alex: Very good points. I have realized this as soon as I saw the second entry in my inbox. There is no way I can compare one dashboard with another. Even though the stated objective is “help a senior manager understand how sales people have done in the last 24 months” several people interpreted this in several ways and some went all the way to show trends and messages based on product, region or customer as well.

    Since my unstated objective is “help Chandoo learn new and awesome-kickass-cool dashboard and charting tricks” I kept quiet.

    I have tried to do some justice by adding comments next to each dashboard to help the voters. But I already know that each of these entries is a winner. Just the fact that these people could do something with the data and make a dashboard showing how they understand it is a HUGE achievement. Not many people (not even 1% of the population) can articulate ideas like these. Kudos…

    @Jon… We need a Pie chart add-in, we need it now. Go release !!! :)

  19. cuboo says:

    @chandoo: Many thanks for the working-hours writing this post. It’s brilliant! So many good visualization ideas … lot’s of things to learn from!

    @alex: I agree with you totally – a dashboard for senior executive has to be as simple as possible and focussed on the performance of salespersons. We should never forget: It’s all about decision-supporting!
    Me neither met a manager who did OLAP-Analysises; they rarely use their computer – here in Germany! They wanted their infos on paper and very often the dashboard – is it a dashboard or a report? – needs to be printed out. That’s the reason, why I didn’t use colours extensively. This makes my dashboard looking grey and not very “sparkling”, even though I used the excellent open-source sparklines-addin from Fabrice as you did :-)

  20. Alex Kerin says:

    @Tony: sorry, the link goes to an xlsm file, which is an Office 2007 file with macros – if you have this it will be automatically recognized. This URL: http://bit.ly/6owMD5 will take to an Excel 2003 file (xls). There will be some loss of fidelity, but you should get the idea.

    @Jon, Chandoo. My example actually contains 5 pie charts, see if you can spot them – couldn’t resist doing that ;)

  21. Jon Peltier says:

    Cuboo -

    A good dashboard report (see, it’s both a dashboard AND a report) is not defined by a fancy color scheme. It is defined by the information it conveys, its clarity, its comprehensiveness, its succinctness. It’s best to use color sparingly, so when it appears, it really means something.

    We don’t pay managers to use their computers (even in the US), we pay them to make wise decisions. One good decision they make is who they rely upon for their information, that is, who runs their OLAPs for them.

  22. TonyP17 says:

    @Alex. Thanks for the link to the Excel 2003 file which I have downloaded successfully. I have also downloaded the Sparklines add-in and will take a lokk when I have some time.
    I am still baffled, however, when you say that Link 1 above takes me to an xlsm Excel 2007. It downloads a zip file (data-visualization-challenge-alexkerin.zip) with many .xml and .rels files.

  23. cuboo says:

    @Jon: Good to read, that things are similar in the US – I do not live “behind the mountains” :-)
    @Alex: I didn’t see you last attempt, but I do not condemn pie charts totally. I like them as small multiples in a table, to visualize the distribution in rows or columns. For example here at the lower end: http://bit.ly/6ZiFJ0 … or here: http://bit.ly/7JVtmj where I used them as a “traffic-light plus”.

  24. Alex Kerin says:

    @Tony: your browser/operating system/virus software is preventing you downloading a macro laden file just in case it has viruses – instead it’s packaging it as a a zip and screwing it up (I would guess)

    @cuboo: my pie charts are actually only the red bullets on the top table with some if statements – don’t know why I used them instead of anything else – because I could?

    @Jon: Couldn’t resist – here’s your ‘senior’ dashboard – spot the egregious visualization mistakes: http://bit.ly/84lET6

  25. TonyP17 says:

    @Alex: something is clearly getting in the way. I have tried another PC at home with the same result.
    Unless you or someone else can help further I will have to speak to my IT manager. I have never had a problem downloading files before.
    Would you perhaps be able to create a valid zip file for me to download?

  26. cuboo says:

    @alex: gorgeous dashboard … if you don’t mind I will start all my presentations with this. I’m quite sure: parts of my audience will love the gauges and 3D-Charts.

  27. Faseeh says:

    @Mr. Chindoo….I am amazed how do U manage these things :) ? It takes me an hour to compose an email…some times..
    @ Cuboo……..a lovely chart.
    Also liked very much charts of Aris & Ajay for color complexion & that of Arti for the complex look that it gives.

  28. [...] der Gestaltung von Dashbords inspirieren lassen will findet bei ihm auch zahlreiche Beispiele für Excel-Dashboards aus dem Vertriebsbereich. Dort gibt es auch viele weitere Links zur [...]

  29. [...] Wer möchte, kann hier bis zum 15.01. für meine Lösung – cuboo, Option 7 – stimmen. Würde mich freuen [...]

  30. Sntosh Chaube says:

    Hey Chandoo, you played Santa a bit late, thanks for this very wonderful New Year`s Gift

  31. Aires says:

    Woohoo! I’ve just come back from my vacation trip (I was afraid of losing senses due to computer abstinence :) ), and am able to see such a delightful set of templates. Thanks everyone, and particularly Chandoo for putting it all together.

    I am not going to vote on anyone, because I am also part of the competition (in fact, it’s because it’s too hard to choose a better dashboard, but justifying by the moral argument sounds better. :o) ). What I would really appreciate, however, is feedback about what I should do to make my charts better (I am particularly curious to understand why Jon left me out his favourite list :) ). As I told Chandoo before, I am really looking after learning about how can I do better dashboards. So, please, help me by criticizing my dashboard. :)

    All the best, and a great 2010 to all of us!

  32. Fabrice says:

    @ Tony17. Some browsers rename the XLAM files downloaded from Sourceforge or Box.net into “XLAM.ZIP”
    Delete the “.zip” extension and things should work out properly or visit
    sparklines-excel.blogspot.com for alternative download links.

  33. keyblanks says:

    Beautiful job,

    I haven’t walked through this yet,

  34. [...] Sales Visualization Challenge? We got 32 extremely good dashboards submitted and finally you voted Alex Kerin’s entry as the winner. So when I informed Alex that he is the winner, I also asked him to send me a pic of [...]

  35. Jpablo says:

    hi everyone, I’m amazed how far can U all get with this challenge
    I want to learn too many thing from here, congrats to all participants and people commenting on this
    single question: I’ve downloaded some files for excel 2003 but I haven’t been able to select a “total” instead of just one Sales Person… my error?
    if so, please tell me how to navigate some of the dashboards aboard starting on the big picture/figure
    regards from Chile
    Jp

  36. [...] Dashboards – A dashboard showing your current performance and positioning in the sales process. – We have provided a great set of excel spreadsheet visuals for you from chandoo.org. [...]

  37. [...] Email: Last time, when I did the sales dashboard contest, I got a ton of emails with entries. It took me countless hours to sort thru the email and [...]

  38. [...] Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations http://chandoo.org/wp/2010/01/04/sales-dashboards/ [...]

  39. zzz says:

    wanted to look at #13, but the file is protected and has a password – so i can play with the dashboard but not see how it is made, which sort of defeats the purpose… any suggestions? :)

  40. zzz says:

    oops, never mind, found it (cell B31). a light-gray note on a white background is particularly easy to see! :)

  41. fred says:

    I need someone to do a sahboard for me if i supply the data. It is a sales dash board – How much could I expect to pay

    • Chandoo says:

      @Fred… Depends on your dashboard. Based on my experience, a typical dashboard takes 6-8 hours of construction time, if the data and outputs are clearly specified. Now, the rates depend on the consultant. I charge $75 per hour, so you can expect to pay roughly $500 if you hire me. Let me know if you are interested.

  42. [...] an year ago, we had a memorable dashboard contest on Sales Dashboards. We got 32 beautiful, outstanding, well crafted entries and it was a lot of fun learning new tricks [...]

  43. baran says:

    hi
    veryyyyyyyyyyyyyyyy good

  44. [...] Sales Dashboards – 32 Examples & Downloads 0.82% page views [...]

  45. hellomoto says:

    In Option 24, how are the four main kpi circles made? That is, those pictures can be moved along with the data inside the picture and they are not groups of objects. So what are they? Are they results of using the Camera tool?

    I like the ease of moving them around.

  46. Hui... says:

    @Hellomoto
    The 4 Circles are in fact camera tools
    The Left most, Best Qtr 2008, is linked to a hidden sheet Control via the formula =Control!$G$16:$I$25
    Unhide the sheet and go to that area
    You will see a circle with a cell reference and a Title and box outline

  47. hellomoto says:

    Thanks Hui. Just did what you suggested and now I am a bit bummed. I thought the circles were cool and thought that the color would change due to the value. But they are fixed objects (i.e. the colors don’t change only the numbers do).

    oh well, i am now inspired to use those colored circles and figure out how to switch between them to show status. Do you have any suggestions on how I might do that (use custom objects as the traffic lights, instead of the standard conditional formatting ones)?

  48. hellomoto says:

    Thanks Hui, I will read it today.

  49. Ganesh says:

    One quick question on Dashboards..
    Can we export these to Powerpoint and do a presentation as we do in Excel?

    Pls ..

    • Chandoo says:

      @Ganesh… You can take snapshots of the dashboards and put them in PPT. But if you want full interactive experience, opening them in Excel is your best bet.

  50. Andy says:

    I made a kick ass dashboard based on my learning from here…..How do I attach the pdf so that others can see what I made……let me know plz.

  51. BigRon says:

    A big thanks to everyone who shares his excel-files! Very useful for noobs like me ;)

  52. Michael says:

    Excel is very useful for building dashboards (among other things).

    If your company is calculating sales commissions in Excel I have found a tool which takes your commissions spreadsheet and generates custom reports for you. I know Excel has their own reports they don’t have any sales specific functions.

    Check out the tool at http://www.oneclickcommissions.com/cha.html

    Thanks for all the documents everyone.

    -Michael

  53. Mathew Patrick says:

    Thanks for getting this compiled, sorted,.. to the point etc(overwhelmed with what i have found on this page.. cant find words).. I now know, how to get started to report a great\WOW looking sales DashBoard .. couldnt have done without this page. Thanks Again!!

  54. Sulabh says:

    Great Site different from the rest.

  55. Amer Al Fawakheery says:

    Great job, thanks for the site manager and for everybody who contribute in this wonderful files.

  56. Brijraj says:

    Hey Chandoo,
    first of all thank you very much for giving us such a nice website.
    your excel templates are too helpful for me in data analysis.
    some graphs became handy for me after i learn it from template.
    thank you again…..
    your work is really appreciable…

  57. florencedhalia says:

    wonderful site! thanks for the file sharing

  58. Thomas says:

    I cannot open the links at work because it is blocked on my cpu. Would it be possible to have these emailed to me – tbutler515@gmail.com. Many thanks.

  59. Ata Betero says:

    Greetings!

    It seems problematic downloading the above. I am not sure what caused it. I hope to hear solutions from you if possible. Anyway I am downloading spreadsheets for teachers and it seems working fine. It is still yet completed but I will comment on it once downloaded.

    Thank you

  60. raghu says:

    help me to get excel notes

  61. [...] or procedure & improve it using readily available tools like Excel. For example, you could improve the sales dashboard that gets emailed every month or manage projects [...]

  62. [...] con esta página, que tiene varios modelos, para que podáis comparar con los [...]

  63. Doug says:

    Hey Chandoo!

    Thanks for all the great information – I especially appreciate the design books you recommend. The Non-designers Design book is a gem!

  64. saravana kumar says:

     
    What a exhalant excel supporter u r sir
     

  65. I like the:  Excel based Sales Dashboard by Pawel (Option 26)

    I clicked on the download option, but it is password protected.  It does not allow me to make modifications to any of the fields. I contacted Chandoo, and was asked to comment here to receive a reply from “Pawel” in order to find out more on how I can use this dashboard for my use.  Thank you.  

    • Zofia says:

      I like the: Excel based Sales Dashboard by Aires (Option 02)
      I clicked on the download option, but I have the same problem like Luis-Alejandro – it is password protected. It does not allow me to make modifications to any of the fields. WIll you enable me to use this dashbort for my use. I would be very greatful

  66. Suan Yang says:

    I like Excel based Sales Dashboard by Duezzz (Option 08)
    But like Luis-Alejandro, I faced the same problem of not being able to download the file because it’s password-portected. Please let me know what I should do in order to download this excel template. Thank you very much!!

  67. [...] that a sales dashboard constructed in Microsoft Excel can have, visit the post titled “32 Examples of Sales Dashboards” at Chandoo.org. This post is literally the largest grouping of excel sales dashboards [...]

  68. marius says:

    great compilation…however duezz’s dashboard is not downloadable anymore and pawel’s is password protected…. why would you protect it ? i thought the whole idea was to share the info and to learn something new…

  69. sergio says:

    Duezzz file is no longer available. Such a pity.

  70. Kelly says:

    I like the : Excel based Sales Dashboard by Pawel (Option 26).
    The date range is useful for my work but I am unable to access the hidden sheet ‘calcs’ due to password protected. Appreciated if you could please email to me the password :)

  71. Ally says:

    Matt Cloves – I really like your dashboard! Can someone tell me how you were able to link the multiple selection criteria into your sumif function? I’m trying to build a dashboard that allows the user to select multiple months and then create a graph based on those months selected. Help!!

Leave a Reply