Everybody already knows the gauge chart. 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.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. The latest version of Ultimate Dashboard Tools enable 12 zones for gauges!
There are a number of ways of showing variance to target in a dashboard. The latest UDT version provide dual gauge chart which is simple to read and gives meaningful comparisons between plan and target or actual vs. budget.
We’ve created traffic light widgets in Excel to display charts that highlight exceptional performance in your reports.
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 tricks.
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! The chart is not only able to handle three categories but a maximum of eight!
Waterfall chart is the important 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. In the version 8.0 we’ve rewrite the code from the ground up. It’s super easy to manage the multiple subtotals!
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.