Sales Analysis Charts in Excel – 78 Alternatives

Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.

How to read this article?

This is a very big page. So let me help you out.

• Each of the 45 contestant’s entries are shown in one box. The box shows one of the charts the contestant has made.
• If the contestant has made more than 1 chart, then thumbnails of remaining charts are shown beneath. You can click on thumbnails to enlarge the images.
• For some charts, I have added my comments.
• You can download the file(s) for each contestant’s charts by clicking download links below the image
• If you want to learn how a particular chart is constructed, refer to Related Articles section
• I really liked some of the entries. You can see “Chandoo’s pick” icon on top of such charts.
• This article is big. So get a cup of coffee and enjoy it sip by sip.

Winner of this contest will be announced tomorrow.

Thanks to Everyone

Many thanks to all the participants of this contest. I have really enjoyed going thru your files and understand the charting techniques you have employed. I learned a lot of interesting techniques too, which I will share on this blog during next few weeks.
Special thanks to Ravindra, my assistant, who helped me in compiling all the results and taking screenshots of the charts.
Also, thanks to Hui, for giving his feedback and suggesting few more picks.

Which charts did you like?

As you can see, there are several excellent charts. I liked the about 14 different entries and marked them all with Chandoo’s pick

What about you? Which charts did you like? Please tell us using comments.

Who is the winner?

I will be announcing the winner of this contest by tomorrow (1st of July).

Related Articles

If you want to learn how many of these charts are constructed, then you must go thru these articles.

• Using form controls
• Display on-demand details in excel charts
• Panel charts
• Comparison charts
• Donut bar chart
• Smart chart labels
• How to make charts when you have too much data
• Dynamic Charts with Check Boxes
• Incell Charts
• Sales Dashboards using Excel
• Excel Dashboards – Information, templates & tutorials
• Dynamic & Interactive Charts in Excel
• Excel Charting Examples & Templates