Setting Up General Chart Parameters

To quickly set up data series format, use the Chart side panel tab.

The following chart series settings are available:

• Chart type settings.

• Border and fill settings and other settings.

The following actions are available on working with charts:

• Changing chart type.

• Setting up chart style.

• Setting up scale orientation.

• Setting up chart border and fill.

• Setting up font and alignment of labels, tips and captions.

To execute advanced setup of data series format, use the Chart Parameters dialog box.

Depending on the chart type the following actions are available:

• Setting up axes.

• Setting up legend.

• Setting up captions.

• Setting up data labels.

• Setting up tooltips.

• Setting up 3D chart.

• Setting up secondary chart.

• Setting up additional parameters.

1. Make sure that the side panel is displayed.

2. Select the chart in the working area.

3. Select the Format radio button on the side panel and go to the Chart tab.

To change chart type:

• Use the ribbon. Click the Type button on the Chart ribbon tab.

• Use the Chart tab on the side panel.

• Use the Chart Type dialog box.

To save chart data series formatting, select the Bind to Source checkbox. After the checkbox is selected, data series formatting will not change in case of dimension selection changes.

NOTE. The setting is available in express reports, and also in regular reports provided that a data source is a data slice file.

To show empty values in the chart as zero values, select the Substitute Empty Values with Zeros checkbox. The checkbox is deselected by default, and empty values are not substituted with zeros, chart area break is displayed.

The left chart shows empty values substituted with zeros, the right chart does not show them:

To set up chart background, specify background fill type in the Fill drop-down list:

• None. Chart background fill is not used.

• Solid Fill. Select the solid fill color in the drop-down palette. The desktop application enables the user to set up chart background transparency.

• Gradient Fill. To set up two-color fill of chart background, specify the start and the end colors of gradient in the drop-down palettes. If required, specify slope angle and transparency percent in the Angle and Transparency boxes.

NOTE. On setting transparency of solid or gradient fill, take into account that 100% corresponds to full transparency (data chart background becomes invisible), 0% corresponds to full opacity.

To show chart border, select the Border checkbox and determine settings of border color and width. The desktop application also enables the user to set up line type for data series border.

It is available for series of linear, scatter, mixed charts, histogram and area chart.

To change scale orientation, select the Invert checkbox. The X axis is oriented from bottom to top, and the Y axis is oriented from left to right. The order of series displaying in the legend is also inverted. When the checkbox is deselected, axis orientation and series order in the legend are restored to the original state.

It is available for series of line, mixed chart, histogram and area chart.

In the Stacking group specify the type of stacking in use by selecting one of the radio buttons:

• None. A chart shows absolute values of a series.

• Absolute. A chart shows values with stacking allowing to assess part of each value in the total sum.

• Percent. A chart shows values as percentage allowing to assess part of each value in the total sum.

It is available for series of line, pie, mixed charts, histogram and area chart.

To show 3D chart, select the 3D View checkbox.

To synchronize chart view with data table, select the Synch with Table checkbox. After selecting the checkbox chart can be scaled.

NOTE. Setup is available only in the desktop application for the Analytical Queries (OLAP), Dashboards tools for line chart, histogram, area chart and mixed chart.

Zoom enables the user to change size of the shown part of the chart with saving of proportions.

To zoom the chart, use the mouse to select the chart part, which is necessary to enlarge. The chart is automatically rebuilt. The plot area will show the part, which was selected. To return the chart to the original view, click the button in the plot area.

There are limitations on working with synchronization:

• The setting is available in the desktop application for series of line, mixed chart, histogram and area chart in 2D mode.

• The setting is available if chart or table data views are located vertically or horizontally.

• The setting is not available on working with regular report charts.

Zoom enables the user to change size of the shown part of the chart with saving of proportions.

Zoom category axis is used to manage chart area view.

NOTE. The setting is available only in the web application for the line chart, histogram, 3D histogram with groups, area chart, mixed chart and stepped chart.

To start working with category axis zoom, enable scroller. To do this:

• Select the Zoom Category Axis checkbox on the Chart tab of the side panel.

• Click the Zoom Category Axis button on the Chart ribbon tab.

After selecting the checkbox the scroller is shown under the chart area, chart zoom is available:

To zoom, point the cursor to the scroller border. The pointer changes to the two-headed arrow:

Click and hold down the mouse button to move the border. The chart is automatically rebuilt. The chart plot area will show the part corresponding to the scroller part:

To move the scroller, point the mouse pointer to it. The pointer changes to the four-headed arrow:

Click and hold down the mouse button to move the scroller part to the required position. The plot area will show the corresponding chart part.

To quick zoom, put the mouse pointer to the scroller or the chart area and scroll up the mouse wheel to zoom in and scroll down to zoom out.

To return the chart to original size:

• Deselect the Zoom Category Axis checkbox.

• Move scroller borders to initial position.

Scroller view is disabled by default.

Below is an example of a stepped chart, in which the following is set up: the 2005 series has a step set up to Left position (from point B to point A); the 2006 series has a step set up to Center position (from point B to point A and to point C); the 2007 series has a step set up to Right position (from point A to point B).

NOTE. Step position can also be set up on the Data Series side panel tab.