how to make a dashboard in excel

Simple DASHBOARD template in Excel without VBA-macros

We offer a simple dashboard without exploitation VBA macros. According to the preferences of subscribers on my Facebook page: https://World Wide Web.facebook.com/excelvisualdata/ about prefer to use Excel dashboards without VBA macros and tertiary-party add-ons. To please the majority, this interactive dashboard guide was created.

How to make an interactive dashboard in Excel without VBA-macros

Simple dashboard without VBA macros.

This dashboard template is designed to perform a visual comparative depth psychology of gross sales for the three product categories A, B, and C. This simple dashboard contains only 4 blocks. For 3 blocks, the accounting point is one week, and for the one-fourth block - 1 month.

Description of charts and graphs on a simple Excel splashboard

Consider each jam individually:

The first block "Mathematical product Sales Ratio" visualizes happening a c-shaped diagram the ratio of the quantity of goods sold for the afoot workweek. IT also displays the ratio of the number of sold trio product groups A, B, and C relative to each other.

As the second block "Daily Sales Shares", a histogram with accumulation is used. With the serve of it, the shares of all group of goods in the total volume of the number amount of goods sold separately for to each one Clarence Day of the week are dead visualized. You can track trends on which day of the week, which aggroup of products is virtually actively or passively sold. Supported this data, tactics or entire merchandising strategies are built to advertise goods in the right clock period. To do this, use: promotions, discount rate coupons, discount programs, contests, etc. etc. In that respect are many selling tools that will not allow your products to settle on store shelves or in sprout balances. It is only important to rigid the end aright and determine the right fourth dimension for their effective application.

The ordinal block "Daily Sales Activity" is a graph with areas for comparing sales activenes in three groups of goods during the current week. It is now important to note that this block is slightly different from the 3 remaining blocks. The fact is that his first data on the Processing mainsheet was disposed in so much a style that the group with the highest sales figures for the current week is forever shifted to the background, and the group with the smallest is ever in the foreground. Therefore, information technology is important to read the legend of the chart connected information technology, since not all week the "C" group is the most active in sales. Consequently, its color may be different, because the orange color is entirely for the type category in the background for this graph. This approach to visualization is made for convenient version of explicit figures in sense modality psychoanalysis.

And finally, the 4th block called "Monthly intermediate sales". This dashboard unit of measurement also has its own peculiarity. Information technology displays curves with average sales for to each one product group for the current 1 month. Therefore, if all the other 3 blocks automatically update their values when dynamic the number of one week in a year, the 4th graph with curves changes its indicators only the month number of the analyzed current year changes along with the workweek number. For example: February starts from the 6th week, and October starts from the 41st week, etc. Total 52-53 weeks in a year.

Happening the remaining side of the dashboard is a weighing machine for visualizing the chosen prevalent period of the yr:

scale direct.

The splasher is controlled using the counter control or by entering definite quantity values 1-53 into cell B22. When dynamic the values in this cell, all indicators on the dashboard change accordingly. And also moves the arrow on the scale. The scale itself is divided into 12 months opposite each month the week keep down is indicated with which the similar month begins. Thus, the numbers on the scale serve as a hint for a quick conversion aside month away entrance the corresponding workweek number in cell B22.

Generally, we got a convenient template for reciprocal visualization of your data on a dashboard:

Easy free dashboard.

download file. Download rich Dashboard without VBA macros in Excel

The initial information, as always, is filled in the "Data" sail. The template does not contain macros, so even a drug user below the average flat of mastering of the universal Surpass program can delete it.