Skip to Content
Author's profile photo Sara G Ayer

Label Based Menu as MENU

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

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      The attachment is text not XLF ???

      Author's profile photo Suman Thangadurai
      Suman Thangadurai

      Unzip and change the extensions to xlf, xlf cannot be attached here.

      Author's profile photo Former Member
      Former Member

      Hi,

      I am unable to see the "Expand Direction" - "Center Down".

      Author's profile photo Sara G Iyer
      Sara G Iyer
      Blog 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

      Author's profile photo Former Member
      Former Member

      Label.png

      Author's profile photo Arun Das
      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