ExcelDashboardWidgets

[dbarnwell]

We are trying to unlock a cell to allow for formatting of a percentage in the configuration page allowing for 2 places, i.e. 22.8% instead of 23%. The cell I am trying to revise is O19

[DashboardWidgets]

Hi dbarnwell

We have updated the original version of the spreadsheets so that the thermometer function is now available in either a rounded number or one decimal place (the number on the thermometer bulb is currently shown as a rounded number and the larger number to the right is shown with one decimal place - if you want to both shown with one decimal place just use the code for the text on the right in the thermometer bulb).

ExcelDashboardWidgets - Updated 150711v2.xls

(635.5 KiB) Downloaded 737 times

Here's a quick image..

Unfortuantely you'll need to import your work into the new spreadsheet format that has this functionality. Alternatively, feel free to send me your spreadsheet (fred@exceldashboardwidgets) and I will update the functionality and send it back to you.

Hope this helps and please get back in touch if you need any more support.

Cheers

Fred

[dbarnwell]

Just the job. Thanks.

[nawaz]

This is exceptionally decent post much appreciated alot..!!