ExcelDashboardWidgets

Helping you create stunning dashboards in Microsoft Excel including dials, speedometers, thermometers, and much more...

Post any problems or questions you have with the ExcelDashboardWidgets spreadsheets here.

Moderator: DashboardWidgets

#341
I would like to use the dial widgets to display percentages. It appears, however, that there is something forcing the display values to round up to the nearest integer value...so all values show "1.0". The needle appears to be pointing in the right direction, so it is clearly a display issue.

Any ideas?
#342
Hi Dial452

You can format the display values any how you like by changing the formatting on the "Dashboard Calculations Page" (i.e. you can configure the value to show a percentage - or you can change the number of decimal places if you wish).

Here is an example of a simple dashboard with percentage values.
Dial452.jpg
(72.24 KiB) Downloaded 325 times
Please note the Dashboard Calculations Tab in this example is locked, the unlocked version can be downloaded in the Commercial License Holder's Download Area here ...http://www.exceldashboardwidgets.com/ph ... f=25&t=115

Hope this helps with your dashboard project and please get back to us if you need further support.

DashboardWidgets

Download and try for free!