Use of Bubble charts to create a traffic light effect

[Former Member]

The circular shape of the series marker in a bubble chart makes it advantageous to be used in a traffic light implementation in Dashboards. This gives a good visual appeal for the end user to know the status of, say data loads happening in a system.

The end users will be eager to know the status of the data loads so that they can quickly start their data analysis. Instead of waiting for a developer to tell him the status, a dashboard (with this traffic light implementation) that connects to the backend system can easily give him the necessary information.

Below are the steps to implement this in your Dashboard:-

1. Pull in a bubble chart and uncheck all the properties like legend, Y-axis, X-axis and so on.
2. Now you are left with a slanting line of bubbles.
3. Use a List Box to hold the names of the Load, so that upon clicking the Load name, the status can be viewed.
4. The load status can in turn be populated in the spreadsheet by BW or QaaWs or any other source.
5. Map 4 chart series-Grey, Green, Yellow and Red with the below properties. All the lights will be light grey in colour by default. Depending on the status of the selected load, the corresponding light will show.

X axis	Y axis	Size
Grey	10	75	1
Grey	10	50	1
Grey	10	25	1
Red	10	75
Yellow	10	50
Green	10	25

6.  The size of the colour Red above is based on the status of the selected load. If the selected load has Failed, then the Size across Red will be 1 else 0. If the selected load is in Progress then the size across Yellow will be 1 else 0. If the selected load has succeeded, then the colour across Green will be 1 else 0.

7.    7.  Change the colour of the individual series in Properties as per the name (Grey, Red, Yellow, Green) and provide the marker size as 100.

Now your Traffic light implementation is ready for use.