Home Page Knowledge Base Support Forum Free Downloads

Changing colors on 'Thermometer'

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

Moderator: DashboardWidgets

Changing colors on 'Thermometer'

Postby nulikiran » Wed Sep 03, 2014 8:16 pm


I am using the 'Thermometer' widget to show the % of errors in applications processed. As an internal service level agreements, we have a bottom line threshold of 6%. This means that (in any given month), there should not be less than 6% error rates of the total applications processed. The 'Thermometer Bulb Circle' and the 'Thermometer Mercury Chart' should be green if the error rates are more than 6%; and red if the error rates are equal to or less than 6%. Is there a way to achieve this?
Posts: 3
Joined: Tue Aug 19, 2014 5:06 am

Re: Changing colors on 'Theremomter'

Postby DashboardWidgets » Tue Sep 09, 2014 12:43 am

Hi Nulikiran

Sorry for the delay - we quickly put this together last week - just didn't get around to posting it back onto the forum until after the weekend.

As you can see the thermometer changes from GREEN > RED based on the cutoff values.

Color Thermometer Widget.jpg

Color Change Thermometer Widget.xlsx
(21.06 KiB) Downloaded 414 times

Please note that you can download the unlocked version of this widget from the Commercial License Holder's Download Area here..


Let us know if you want a quick video explaining how it works and how to set it up in a new worksheet.

Feel free to let us know if you have more questions.


Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Return to 3. Help! I Have a Problem, Can Someone Give me a Hand?

Who is online

Users browsing this forum: No registered users and 1 guest