What are Ultimate Dashboard Tools?
The Ultimate Dashboard Tools is a professional Excel dashboard and chart add-in. We proudly announce that we passed over 3000 downloads! Add-in is used in many different sectors.
The reason for this because of its flexibility it can be used to make almost any kind of KPI dashboard template.
At the very beginning (in 2013) we only had one Gauge Maker and some simpler tool in our hands. Since then the Ultimate Dashboard Tools has grown into a powerful Excel dashboard add-in.
We have paid great attention to building in automated Excel charts and we hope you will like the new stuff! In the past years we have spent considerable amount of time and human resources to development.
Considering the positive user feedbacks we have decided to use better functions than we have used ever before. Of course our prices will remain the same and it will be like this in the future also!
There isn’t any long standing or well working recipe in the world of data-visualization and Excel. Our product would like to give help to find the best method.
The main goal is to make professional Excel dashboard templates in minutes!
Automated Live Gauge Charts
They are so popular that couldn’t be left out from the newest Microsoft BI tool and PowerBI. These are about solutions capable of creating real time dashboards.
Here is the specified article where you can find all the details about it. And here is a video tutorial where you can watch it “live”.
We have already said that there are no limits any number of gauge can be used on a dashboard. Fully automated operation and stability are its characteristics.
Traffic Lights Widget
Let’s continue the introduction with the traffic light widget!
The traffic light widget has countless advantages. Here we would like to point out two of them.
The first is that they alert in such cases that we probably wouldn’t even notice at first glance.
Their second advantage is the excellent opportunity to create management reports and Excel dashboards. The Traffic Lights Widget operates on a similar principal as the Gauge Chart. We can set arbitrary values which changes based on auto-update when values of the cells are changing.
We’ve created an elegant userform that is easily understandable even for new Excel users.
Bullet Chart Tool
This is the newest and strongest element of the Ultimate Dashboard Tools. The bullet chart is a special kind of chart. Our long time desire (not only ours but our user’s wish also) has come true with the introduction of this tool.
Excel default doesn’t support its use. We have by-passed this problem with some VBA programming. Its biggest advantage is the space-saving.
Take a look at the pictures below. The display of the values of plan / actual values are really simple like this!
An ordinary bullet chart usually can handle 3-5 zones / values, the red / yellow / green zone of the key performance indicators, and also the values of plan and actual.
Somewhat like this:
Wow, how did this chart was created? It is hard to believe but the only thing has to be done is to highlight the columns containing the base data.
After this you don’t have to do anything but to click on the bullet chart icon on the ribbon. Your chart is done! We manage all the time consuming algorithms in the background. You only have to pay attention to the dashboards.
Advanced Bullet charts
Furthermore, we also have a good news.
We let our imagination run free so you can reach the maximum marketing profit. The chart is not only able to handle three categories but a maximum of eight!
We have developed an app that far surpasses the opportunities of the classical bullet chart. So everybody can find the most suitable settings for them. The advanced edition of the bullet chart.
Waterfall chart is the first element of the Ultimate Dashboard Tools. The waterfall diagram is a visualization tool that is able to show various effects. It gives help to the itemized tracking of plan / actual differences. The diagram grows or decreases from a starting value due to various effects. Thus reaches final value.
This type of diagram unfortunately is only supported by Excel 2016. We have two choices. We can make it manually or we can choose automatized solution.
With the help of the Ultimate Dashboard Tools we can make waterfall charts with the push of a button also in Excel 2010 and 2013 versions.
Some of the main utilization fields of it are marketing and revealing the reasons of profit change.
Marketing and profit is changing year by year. The difference between the years can be due to several effects. We gather them into categories. Finally we portray the effects to the result caused by the changing of category values.
Quick Variance Charts
We can create the horizontal and vertical chart with a push of a button. We only need to highlight the plan and actual data rows.
After this from the ribbon the appropriate icon can be used. We reach the needed result in a blink of an eye.
It is good to know that the dynamic chart principal is in effect here too. If we change the value of one cell than the chart will change in real time.
Tree map Chart
Finally let’s say a few words about a special type of chart! With the help of Treemap Chart Utility you can make spectacular data-visualization without programming knowledge.
On this picture we have portrayed the marketing results of an international company. The surface of the squares are proportional to the profit obtained by marketing. We have created all this from a chart containing two columns (name of the country, quantity) with a single click of a button.
We have developed the Excel dashboard add-in that you can apply arbitrary color scale for marking the minimum and maximum values. The add-in enables the use of the chart in Excel 2010 and Excel 2013 also.
Gantt chart Maker
The Gantt chart is one of the most important helping tool of Excel project management.
The userform can be seen on the picture will appear by clicking on the Gantt chart icon.
After setting some parameters the Gantt chart is instantly available.
Important information about the UDT
A lot of prospective customer asks what kind of support they will have after the purchase of the program.
As we stated on the FAQ page we do not have any monthly fees and after purchase we provide life-time free updates.
The support is free, fortunately we hardly ever have to intervene!
If you have any questions please use the contact form.
We try to answer every question as soon as possible.