Skip to Content

In a huge dashboard there are several tabs, and usually there most have the space constraint.

Below is the easy way to overcome this.

1. Lets assume the menu names be Year, Quarter and Month.

Take a Label Based Menu and map B6 to B8 to labels , and B4 be the destination

for all the label based menus used here.

Make the Changes as  in the Screen shots below. In Appearance tab – > Text -> Title ,

of Label based menu uncheck/remove the Title.

Capture1.PNG

Capture2.PNG

2.     Place a Rectangle and a label on top of this label based menu such that it covers the Label based menu.

B2 =//  IF(OR($B$4=B6,$B$4=B7,$B$4=B8),1,0)

Drag it till D2.

Place a Rectangle and a label on top of this label based menu such that it covers the Label based menu.

Rectangle:

B1 //

=IF(B2=1,”(0,0,192)”,”(255,255,255)”)

Drag it till D1. Bind the rectangle to this cell B1.

Label:
B3 //

=IF(B2=1,”(255,255,255)”,”(0,0,192)”)


Drag it till D3. Bind the Label ( appearance -> text -> Label ) to this cell B3.

Capture3.PNG

Capture4.PNG

RESULT :

Capture5.PNG

Thanks for the read. The .xlf is attached with this Document. PFA, and rename the extension to .xlf.

Happy Learning!

Sara

To report this post you need to login first.

6 Comments

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

    1. Sara G Iyer Post author

      Hi Garimella,

      By default it is centre down. It should be there. Please attach the screen shot of the drop down list you are getting.

      Thanks,

      Sara

      (0) 
  1. Arun Das

    Hi Sara,

    Nice work. But i unzipped the file you have send and given .xlf extension.

    While opening its Shows an error./wp-content/uploads/2014/06/issues_473997.png

    (0) 

Leave a Reply