ExcelDashboardWidgets

[Clemenceboon]

Hi,

Regarding the "daily visitors" widget, can it be possible to add a third colorr to the cell change ?

Ex: if there are from one to 500 visitors : RED
If there are between 501 & 1000 visitors = YELLOW
More than 1001 visitors = GREEN

Thank you in advance for your help,

Clémence

[DashboardWidgets]

Hi Clemence

Yes this is possible - you can have as many color changes as you wish.

The easiest way to understand what this widget is doing and how it is constructed is to look at the individual Excel objects that make up this widget...

HOME > FIND & SELECT > SELECTION PANE

The rectangle that changes color is essentially a bar chart and can be set up to change color depending on the number of visitors.

Take a look at the example attached.

Traffic Light Daily Visitors Widget.jpg (15.51 KiB) Viewed 2498 times

Traffic Light Daily Visitors Widget.xlsx

(22.29 KiB) Downloaded 353 times

By the way, I would also take a look at the traffic light thermometer widget that we developed that works on the same principles - however uses a pie chart and a bar chart. http://www.exceldashboardwidgets.com/ph ... ?f=9&t=334

Feel free to get in touch if you need further assistance.

Cheers

DashboardWidgets