ExcelDashboardWidgets

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

Please post your comments related to configuring the ExcelDashboardWidgets spreadsheets here.

Moderator: DashboardWidgets

By agreiff
#622
Hi!

I'm very pleased with the dashboard widgets! But I'm struggelig to make the wanted adjustments to the dial widget.

I'l like to have 2 colored dial (green - on target and red - below target). How could I tune the wiget to get this?

Best regards
Anders
User avatar
By DashboardWidgets
#623
Hi Agreiff

Great to hear that you are please with the dashboard .

Are you having problems ungrouping the widget and changing the colours of the segments?

Is this roughly what you are trying to achieve (see image below - four segments green and one red)?
Health Facility.jpg
If it helps, there's a tutorial on changing the dial colours here http://www.exceldashboardwidgets.com/ph ... p?f=7&t=67

Alternatively there are some custom designs with 3,4 and 6 segments here http://www.exceldashboardwidgets.com/ph ... &t=68#p444
3, 4, 5 Alerts.png
If this isn't what you are looking for, feel free to make a rough sketch of what you are after (and scan it) and we'll have a go at making it for you!

Alternatively, we can make a short video tutorial to explain the steps.

Warmest regards

DashboardWidgets

Download and try for free!