Skip to Content

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.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Matt Toader

    Hi,

    Why isn’t it easier to use 3 circles which have the colour bound to 3 cells that change the colour according to the values in a cell?

    Something like:

    if cell1<3 red else gray (the top circle’s color)

    if cell1>7 green else gray  (the bottom circle’s color)

    if cell1<=7 and cell1 >=3 yellow else gray (the middle circe’s color)

    …and thats the trafic light effect.

    Regards,

    Matt  

    (0) 

Leave a Reply