Skip to Content
Author's profile photo Sara G Ayer

New Dashboard Component : Lamp/Bulb Chart

One another creative component. Which can be made easily, which looks classy and catchy.

It may be little longer than my other blog posts , but bear with me, because the result of this is worth the pain. 😉

So this is how the Component look like.

0.PNG0_1.PNG

1.PNG

2.PNG9.PNG

2_1.PNG

3.PNG

3_1.PNG

4.PNG

5.PNG

6.PNG

7.PNG

7_1.PNG

8.PNG

This one is for the reference. I2 and J2 cells are filled with the corresponding colour of G2 and H2 respectively

where in R is red, G is green and, Y is Yellow.

Thats how it is done. 😀 !

10.PNG

Thanks for Reading.

.xlf is enclosed for more clearer explanation. Change the extension to .xlf to use the same.

Regards,

Sara

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mahantesh Hiremath
      Mahantesh Hiremath

      Hi Sara,

      This is very creative dashboard. Thumbs up..

      🙂

      Thanks and Regards

      MAHANTESH

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Mahantesh! 🙂

      Author's profile photo Former Member
      Former Member

      Hi Sara,

      Nice Presentation!!! 😎

      Thanks,,,

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you lilkar a

      Regards,

      Sara

      Author's profile photo Former Member
      Former Member

      Hi Sara,

      Another creative yet excellent dashboard.

      The more posts you blog, the more precise you are!!

      Keep posting.

      Regards,

      Mubashir Hussain

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Mubashir Hussain ! Glad to share.

      Regards,

      Sara

      Author's profile photo Former Member
      Former Member

      Dear Sara,

      I have SAP Bex Query data like "country,states ,city,sale price,QTY" but i want to create dashbord by using "Query Browser" ........HOW?

      Requirement :

      1. country values in listbox if select country(IND)

      2. Display " IND" related "States" and "Sale price" in pie chart 

      3.If click pie chart on states then display "city's  & qty" in bar chart



      Plz Sara i need this requirement with screen shorts ....(gtr.venkat@gmail.com)



      Regards,

      Venkat.

      Author's profile photo Former Member
      Former Member

      hey sara, nice one, this ones catchyyy 😉

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Yash.