Use Charts

These features are available to both designers and end-users.

Charts provide many features for customization and exploration. These features are described in the sections below. After you modify a Chart, you can save your changes (if desired) in one of the following ways:

Chart Toolbar

If the Chart mini-toolbar obscures Chart data, press the ‘Hide MiniToolbar’ button close to temporarily hide it.

The mini-toolbar at the top of a Chart often provides a variety of tools for navigating and adapting the Chart. The table below lists the options that you might see in the toolbar. Some options are available only when you select data on the Chart.

UserChart1

How to select Chart data:

You can select contiguous or discontiguous data in a Chart:

  • Drag the mouse across the data you wish to select. Hold the Ctrl key and drag to add additional regions to the selection.

  • Hold the Ctrl key and click the data you wish to select.

  • Hold the Ctrl key and click the X-axis labels to select the corresponding data.

  • Hold the Ctrl key and click the legend labels to select the corresponding data (subseries).

‘Hide MiniToolbar’ button close

Temporarily hide the Chart toolbar.

‘Drill Down Filter’ button drill down

Drill and filter at the same time. See Drill Down and Filter in Drill Down into Data.

‘Brush Chart’ button brush

Highlight selected data across multiple Charts. See Brush a Chart in Drill Down into Data.

‘Zoom Chart’ button zoom in

Zoom into the selected Chart data. See Zoom a Chart in Drill Down into Data.

‘Exclude Data’ button eye off

Zoom into the non-selected Chart data. See Zoom a Chart in Drill Down into Data.

‘Show Summary Data’ button show summary

Display the Chart aggregates in tabular form. See Export Chart Data in Export a Dashboard.

‘Show Details’ button show detail

Show the pre-aggregate detail data in tabular form. See Drill to Chart Detail Data in Drill Down into Data.

‘Show Enlarged’ button expand

Temporarily increase the size of the Chart to full screen.

‘Edit’ button edit

Open the Chart Editor. See Basic Charting Steps for information on how to use the Editor. This option may not be available for all Charts.

‘More’ button (menu horizontal) > Properties

Open the ‘Chart Properties’ dialog box. See Chart Properties. (Some options may not be available.)

‘More’ button (menu horizontal) > Format

Opens the Format panel. See Add Visual Format. (Some options may not be available.)

‘More’ button (menu horizontal) > Save As Image

Export the Chart as an image. See Export a Chart as Image in Export a Dashboard.

‘More’ button (menu horizontal) > Resize Plot

Change the spacing of Chart data elements. See Basic Charting Steps.

‘More’ button (menu horizontal) > Date Comparison

Perform a wide variety of date comparisons (e.g., last year vs. this year) on Chart data. See Compare Data by Date.

‘More’ button (menu horizontal) > Show All Titles

Display any Chart titles that have been hidden.

‘More’ button (menu horizontal) > Show All Axes

Display any Chart axes that have been hidden.

‘More’ button (menu horizontal) > Show Legend

Display any hidden legends.

‘More’ button (menu horizontal) > Annotate Component

Add annotations to the Chart. See Annotate a Dashboard.

Right-Click Options

You can right-click various areas of a Chart to get options specific to that region.

Axis Title

Right-click an axis title to view title-specific options such as the following:

UserChart2

Title Properties

Opens the ‘Title Properties’ dialog box. See Axis Title Properties.

Format

Opens the Format panel for the title. See Add Visual Format and Add Data Format. (Some options may not be available.)

Hide Title

Hide the title.

Axis

Right-click an axis to view axis-specific options such as the following:

UserChart3

Axis Properties

Opens the ‘Axis Properties’ dialog box for the axis. See Axis Properties.

Format

Opens the Format panel for the axis. See Add Visual Format and Add Data Format. (Some options may not be available.)

Hide Axis

Hide the axis.

Data Point

Right-click on Chart data to see the ‘Annotate Point’ option. See Annotate a Data Point in Annotate a Dashboard.

Legend

Right-click a legend to view legend-specific options such as the following:

UserChart4

Legend Properties

Opens the ‘Legend Properties’ dialog box for the axis. See Legend Properties.

Format

Opens the Format panel for the legend. See Add Visual Format and Add Data Format. (Some options may not be available.)

Hide Legend

Hide the legend.

Ad Hoc Editing

Press the ‘Edit’ button edit in the Chart mini-toolbar to open the Chart Editor. This provides extensive capabilities for modifying the Chart. See Basic Charting Steps for information on how to use the Editor.

This ‘Edit’ button edit may not be available for all Charts.