Under Interaction Options, in the Insert On list, select Mouse Click to insert the data when the user clicks the chart or Mouse Over to insert the data when the user moves the mouse pointer over

the chart selection.

11. Under "Default Selection", in the Series list, select the series and, in the Item list, choose the item that is selected by default when the model loads.

The chart is configured to insert data into a destination range when a selection is made. The data in the destination range can be used by another component in the model.

To finish configuring drilldown capabilities for the model, you must place another chart on the canvas and configure it to display the filtered query data or the data inserted into the destination range.

Related Topics

•Binding components to data sources

•Using chart components

•Chart insertion properties

4.2.2.3 Chart behavior properties

Use the following table as a guide for setting properties on the Behavior view for charts. Note that some options are available only for specific chart types.

Description Option

Common tab

Specifies whether blank cells at the end of the data are displayed on the chart or ignored.

Set any of the following options:

• In Series: The chart does not display empty series past the last non-empty series in a range.

• In Values: The chart does not display empty values past the last non-empty value in a series.

For more information about using this option, seeWorking with variable amounts of data.

Ignore Blank Cells

For a sparkline chart, select this option to enable an area of color behind the sparkline to indicate the range of normal values for the given data.

Normal Range Area

Select this option to set the normal range area based on the variance of the data.

Auto

Select this option to set the normal range area based on specific low and high values. Enter the low and high values or click the Cell Selector ( ) to select a source data location for these values.

Manual

Specifies whether users are able to adjust the chart scale during runtime.

If this option is selected, when the model runs, a set of runtime tools is available and allows users to adjust the chart scale. You can also select which tools are available in the runtime tool set. For more information about using this option, seeAllowing users to adjust chart scales.

Enable Run-Time Tools

Description Option

Adds a range slider to allow users to focus on a particular data set rather than viewing the entire chart at once. Users can change the size of the range by adjusting control handles on either side of the range slider. For more information about using this option, seeAdding range sliders to charts.

Enable Range Slider

Sorts the chart values according to specified data series or chart labels.

Select one of the following options:

Description Option

Sort according to the data values.

If the chart has multiple series, in the Series list, select the series to sort on. In the Order list, select Ascending or Descending.

By Data

Sort by category axis labels.

Labels are sorted alphanumerically in ascending order. To sort in descending order, select the Reverse Order check box.

By Category Labels Enable Sorting

This option allows you to specify conditions that control when the chart is visible during runtime. For more information about using dynamic visibility, seeManaging the visibility of components.

Dynamic Visibility

Scale tab

Use these options to specify how the scale looks on the chart. For more information, seeConfiguring scales.

Scale

Configure how many dividing lines appear on the chart. For more informa-tion, seeConfiguring scales.

Divisions

Animations and Effects tab

When enabled, data animations add movement to chart components. For example, in bar charts the bars gradually increase or decrease in size, and in point-based charts, the points slide to their new position as the data changes. When not enabled, the value markers jump to their new position when the data changes.

Enable Data Animation

Description Option

Select how you want the container to appear on the canvas when the model opens or when the dynamic visibility of the container is triggered.

You can select a Type of entry effect and specify its Duration.

Entry Effect

Related Topics

•To configure component properties

•Chart general properties

•Chart insertion properties

•Chart appearance properties

4.2.2.3.1 Configuring scales

The scale controls how data is plotted on the chart and how the chart axes adjust as the data values change.

Note:

Scales do not apply to pie charts, tree map charts, or sparkline charts.

You can allow chart scales to adjust automatically based on the data. However, depending on what the data is showing, it may be more appropriate to set the scale manually. If you set a manual scale, the scale does not change to accommodate the data and if data values exceed the chart range, they do not appear on the chart. For example, if your data is represented as a percentage of a specific quantity, it may not be appropriate to include 120%.

You can also specify the scale format as either linear (based on addition) or logarithmic (based on multiplication). In general, logarithmic scale are well-suited to larger number ranges and data that contains a wide variation of values.

Note:

If you want to allow users to adjust the scale at runtime, enable runtime tools on the Behavior >

Common tab.

Related Topics

•Allowing users to adjust chart scales

•Chart behavior properties

To configure chart scales

Follow these steps after placing a chart on the canvas and linking it to cells in the embedded spreadsheet.

1. Select the chart and open the "Properties" panel.

2. In the "Properties" panel, click Behavior > Scale.

3. If you are configuring a bullet chart and you want to configure a different scale for each series, select the Configure Scale by Series option. Then select the series that you want to configure from the list.

Use this option when you need to display metrics that are not closely comparable within a single scale or when the series use different scale measures such as percent, count, and dollars.

4. Under "Scale", select one of the following options:

• Manual Axis

Select this option to set fixed scale limits that will not change to accommodate the data values.

If the data values exceed the specified scale range, the markers do not show the outlying values.

Users can see the values when in a tooltip when they move the mouse over the marker. If you select this option, set the Maximum Limit and Minimum Limit for each scale axis.

• Auto Axis

Select this option to allow the scale limits to change to accommodate the data values, then set the following options:

Description Option

Select this option if you want the scale to grow as data values increase, but not shrink when the values decrease. This option minimizes the number of times the chart must rescale and is useful to reduce the impact on performance when the chart is included in an animation.

Allow Zoom Out Only

If Allow Zoom Out Only is selected, adjust the zoom sensitivity. This slider determines how much the axis scale increases as the chart values increase.

Zoom Sensitivity