Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A Sheet is where you create Views by arranging data with drag and drop by placing Dimensions and Measures into decks. Each sheet, whether it's a Dashboard or Worksheet, is displayed as a tab at the bottom of Visual Analytics.

Image Modified

Add Worksheets

...

Click the [Add Worksheet] icon at the bottom of Visual Analytics or use the [Worksheet > New Worksheet] menu in the menu bar.

Image Modified

You can also left-click a sheet tab and choose [New Worksheet]. When a new Worksheet is created it appears in a new tab at the bottom of Visual Analytics. 

...

You can rename a worksheet by double-clicking the tab text. You can also left-click the tab text > from the context menu > click Rename. When the text is highlighted in blue, you can type in a new name. See Also, Chart Title.

Image Modified

Info

If you rename the Worksheet tab, the chart title is automatically updated if the chart title has not been explicitly modified.

...

To show or hide title from the toolbar

  • On the toolbar menu, click Worksheet > Show Title.

Toggle the check on or off to show or hide the title.

Image Modified

To show or hide title from the chart view

  1. Right-click anywhere in the chart title.
  2. Select Hide Title.

...

The color of a Sheet Tab can be changed by clicking on the Sheet's tab menu triangle and selecting [Tab Color].

Image Modified

Once the Tab Color Dialog appears a color can be selected. This color is used to color the background of the tab.

Image Modified

Duplicate Worksheets

To duplicate an existing Worksheet or Dashboard, left click its tab and select [Duplicate Worksheet]. This is useful for making a copy of your work so you can make modifications on existing views without altering the original content. 
Image Modified

Info

It is a good idea to duplicate a sheet that contains a view you have already built before you begin to make changes, so you have a copy of your previous work. You can also use Undo and Redo if you need to undo/redo an action you performed.

...

Original ViewPivot Grid View

Image Modified

Image Modified

Clear Worksheets

...

  • Click Worksheet > Clear > Sheet on the Visual Analytics menu bar 
    Image Modified
  • Click  on the Visual Analytics toolbar
  • Use Alt+Shift+Backspace (Option+Shift+Backspace on Mac) keystrokes

...

To delete a Worksheet or Dashboard left click on its tab at the bottom of the Visual Analytics and choose [Delete].

Image Modified

Info

All references to the worksheet must be removed before deleting it is permitted. Worksheet Tabs that are in use within a Dashboard will have their [Delete] option grayed out until all references to it are removed. 

...