img2
Sales Dashboard – nice combination of 12 static & 4 dynamic charts
Created by: lcartwright

 

About Dashboard:

This dashboard shows company’s sales by region, product, customer & sales analysis month-wise. There are 12 static & 4 dynamic charts in this dashboard.

If you want to track conversion rate by team, you’ll be able to identify the strengths and weaknesses in the sales process. The key focus of this dashboard is to show sales credibility& management visibility.

There are several ways in which you can visualize sales data to understand the market trends and sales performance. In October, ExcelForum team launched a dashboard competition in which you were asked to visualize sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.

In this article, we will show you the steps on how to create this dashboard.

Let us see how the Dashboard made by lcartwright looks:

img1

We have divided this dashboard into 8 sections of information. Let us take a look at each one separately.

Section1:

This section shows sales performance for region 1 & associated products for the year 2011 & 2012.

img2

Section2:

This section shows sales graph of region 1 for selected customer from the drop down list for the related products, for the year 2011 & 2012.

img3

Section3:

This section shows sales performance for region 2 & associated products for the year 2011 & 2012.

img4

Section4:

This section shows sales graph of region 2 for the selected customer from the drop down list for the related products, for the year 2011 & 2012.

img5

Section5:

This section shows sales performance for region 3 & associated products for the year 2011 & 2012.

img6

Section 6:

This section shows sales graph of region 3 for the selected customer from the drop down list for the related products, for the year 2011 & 2012.

img7

Section 7:

This section shows sales performance for region 4 & associated products for the year 2011 & 2012.

img8

Section 8:
This section shows sales graph of region 4 for the selected customer from the drop down list for the related products, for the year 2011 & 2012.

img9

Using this dashboard we can get a clear view of the Sales industry;and thus we can get the information from various points of view.

Download Dashboard

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube