Data Visualization as Charts

A chart is a means of visual displaying table data and is used to graphically present data.

Chart Structure

A chart retains a connection to data, that is, any change in table data results in redrawing the chart taking into account these changes.

Main Operations for Working with Chart

To change chart type, select chart type in the Chart object's context menu on the Sources side panel. The menu includes the items corresponding to various chart types.

The chart is rebuilt according to the selected type.

To rename a chart, select the Rename item in the Chart object's context menu on the Sources side panel.

After the command is executed, the box with object name becomes active. Enter new chart name to the box.

To set up chart general properties, use the General Settings group of parameters on the parameters panel.

Set up object properties

To delete a chart, select the Delete item in the Chart object's context menu on the Sources side panel.

A confirmation will be required.

Working with Chart Elements

To set up data series, use the Data Series group of parameters on the side panel.

To set up series groups, use the Series Groups group of parameters on the side panel.

To set up a series point, use the Data Series Point Format group of parameters.

To set up legend position and formatting, use the Legend group of parameters on the side panel.

To set up a chart category axis, use the Category Axis (X) group of parameters on the side panel.

To set up a chart value axis, use the Value Axis (Y) group of parameters on the side panel.

To set up a chart secondary axis, use the Value Axis (Secondary) group of parameters on the side panel.

To show or hide data labels, use the Data Labels group of parameters on the side panel.

To set up level lines, use the Level Lines group of parameters on the side panel.

Working with Chart Data

To activate the chart, execute the operation specified in the Object Properties group of parameters.

Data drill down is the operation, which enables the user to move through data levels: from totals to detailed ones. Available drill down depth is determined by the hierarchy of the data source dimensions.

Data drill up is the operation opposite to data drill down, which enables the user to move from detailed data to generalized one.

NOTE. Data drill down is unavailable for data series corresponding to calculated values.

To drill down or drill up data:

Activate the chart.
Select the Drill Down or Drill Up item in the data series's context menu.

Change selection manually on the selection panel if there is no data on the selected level during drill down or drill up.

To exclude a series from the chart:

Activate the chart.
Click the series marker in the chart legend. Series marker will change indication. The selected series will not be displayed in the chart plot area:

The series will be displayed in the legend as a marker with label.
For elements corresponding to the excluded series, checkboxes will be selected in the dimension.

To include a data series:

Activate the chart.
Click the marker of the excluded series in the chart legend.

For example, the chart on the left displays all series, the chart on the right displayed the Tver Region series that was excluded: