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.
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.
Drag it till D1. Bind the rectangle to this cell B1.
Drag it till D3. Bind the Label ( appearance -> text -> Label ) to this cell B3.
Thanks for the read. The .xlf is attached with this Document. PFA, and rename the extension to .xlf.