Hiding Items in a Single Chart or Table
Hiding Items in Your Entire Workbook
Hiding Items for All New Workbooks
Hiding Items in Your Entire Workbook
Hiding Items for All New Workbooks
If you do not want to display a certain item (e.g., an unwanted owner, tag, or IPC), you can hide it on three different levels: only in one chart or table, for all widgets in an entire workbook, and even for all future workbooks created in your account. Such a setting can be helpful for example if you want to hide an owner which is not relevant for your analyses.
Note: Hidden items are still part of the analysis. The only difference is that they are not displayed anymore.
Hiding Items in a Single Chart or Table
In a chart or table, click on the item you want to hide (E.g., the owner "Johnson & Johnson").
|
|
In the drop-down menu, click on the eye icon to hide this item only in this chart or table.
|
Hiding Items in Your Entire Workbook
You can use the settings of one chart or table to hide an item for all widgets in your entire workbook.
Click on the gearwheel icon to access the chart or table settings.
|
|
Access the tab "Filter and Sort" under the tab "Bars".
Note 1: If you are using a different chart type, access the tab "Columns", "Lines", "Slices", "Bubbles", "X-Axis", "Y-Axis", "Map", or "Sectors", respectively.Note 2: If you are working in a table, click on the name of vertical grouping displayed in the table header (e.g., "Owner"). |
|
Hover over the item you want to hide and click on the eye icon to hide this item (e.g., "Johnson & Johnson"). | |
Items that you have already hidden only for this chart or table, as described in → Hiding Items in a Single Chart or Table, are already unchecked (e.g., "Johnson & Johnson"). You can use the checkboxes to hide or to unhide further items only in this chart or table.
|
An overview of all items that are hidden for your entire workbook is available under "Options" > "Manage Hidden Items".
Access "Options" in the main tool bar and select "Manage Hidden Items".
|
|
Items that are hidden in all charts and tables in this workbook are listed under "Hidden Items in Current Workbook" (e.g., "Johnson & Johnson"). To unhide such items via this dialog, click on the X icon.
|
|
In the chart or table settings, items that are hidden for the entire workbook are highlighted. To unhide such items via the chart or table settings, click on the crossed out eye icon. |
Hiding Items for All New Workbooks
Access "Options" in the main tool bar and select "Manage Hidden Items".
|
|
Under "Hidden Items in Current Workbook", select an item you want to hide for all new workbooks created with your account. | |
Use the arrow icon to move an item into the right column "Items Hidden by Default for New Workbooks". | |
Items displayed in the right column will be hidden by default in all new workbooks created with your account. |