In this article:

Series Sequence Order

Displaying/Hiding a Series in a Chart

Series Type

Series Line Smoothing

Series Fill

Border

Step Position

Series Line

Markers

Data Labels

Plotting a Series on a Secondary Axis

Trend Line

Color Scheme

Visibility of Connecting Lines

Data Series

A data series is a chart element that is a data array. A chart is based on a set of data series.

Data series are shown graphically on the chart, for example, as a set of colored columns.

A chart data series which has a name is highlighted in a specific color and an icon specified in the legend.

NOTE. By default, no more than 99 series can be displayed on a chart. If the greater number of series is selected, the first 99 series is displayed, the rest is hidden. To change the maximum number of series displayed on a chart, use registry settings.

Examples of series for various chart types:

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

To open the Data Series group of parameters

NOTE. The number of displayed settings depends on the chart or series type.

By default, the All value is selected in the Series drop-down list for all chart types, except for the following: waterfall chart, stock exchange chart, box chart, and histogram with fluctuation intervals. This value is used to determine settings applied for all series displayed in a chart. Waterfall and stock exchange charts by default display the series, for which the chart was built.

Parameters available for the All series:

NOTE. Parameters available for the All series depend on the chart type.

To set up a specific series, select it in the Series drop-down list. To set up all series, select the All series. Note that the setting determined for the All series do not overwrite the settings determined manually for a specific series.

To apply settings of the All series for all series, including the series with custom settings, click the For All button.

The data series setup panel looks as follows when a specific series is selected:

Set the parameters:

Series Sequence Order

In the Order drop-down list select the series sequence order in a chart. Series numbering starts with one.

NOTE. Changing series sequence order in a chart is available for all chart types, expect for waterfall chartand stock exchange chart.

The order of a series on a chart determines the order of its displaying in the legend.

Setting up the order of series on a chart is also available in the Series Groups group of parameters for histograms of the Stacked Histogram with Groups and Stacked 3D Histogram with Groups types.

Displaying/Hiding a Series in a Chart

To set up displaying a series in a chart, use the Show in Legend checkbox. The checkbox is selected by default, and a series is displayed in a chart.

NOTE. Showing or hiding a series in a legend is available for all chart types, except for waterfall chart.

Series Type

To change a series type for mixed and radar charts, select the type in the Series Type drop-down list:

Below is the example of a mixed chart with various settings of one of data series (Line, Column, and Area, respectively):

The following series types are available for stepped charts:

Below is the example of a stepped chart with various settings of one of data series (Stepped Chart and Stepped Area Chart, respectively):

Series Line Smoothing

Line smoothing is used to eliminate curved line effect that occurs on plotting line charts and radar charts, a series of the Line type of mixed chart, and of scatter chart with connecting lines.

To smooth chart linear series, select the Smooth Line checkbox.

Series Fill

To set up series fill, open a drop-down palette and select fill type in the drop-down list:

NOTE. Series fill is available for all chart types, except for the following: line chart, scatter chart and stock exchange, and for all chat types, except for the Line and the Stepped Chart types.

If the All value is selected in the Series drop-down list, the checkboxes will be available depending on the fill type in use:

NOTE. If any chart series has its own fill, it remains regardless of the checkbox state. To apply the specified fill to the entire chart, click the For All button.

All checkboxes are deselected by default.

Border

To set up a data series border, set the following:

NOTE. Series border setup is available for all chart types, except for the following: line chart, scatter chart and stock exchange chart, and for all series types, except for the Line and the Stepped Chart types.

Step Position

Step is a curve connecting two neighboring series values.

To change step position relative to a data series point, select the required position option in the Step drop-down list: left, center, or right of the series point.

NOTE. Step position setup is available only for stepped charts.

Below is the example of stepped chart with various step positions (Left, Center, and Right, respectively):

Series Line

To set up a series line, set the following:

NOTE. Series line setup is available for line chart series, and for series of the Line type in mixed charts, stepped charts and radar charts.

Markers

A marker is a single value of a data array displayed as a point of a shape.

To set up displaying of series markers, make sure that the Markers checkbox is selected on the parameters panel:

NOTE. Maker displaying setup is available for series of a histogram with fluctuation intervals, line chart, scatter chart, stock exchange chart, box chart, box chart with linear series, for series of the Line type of mixed charts and radar charts, for a series of the Stepped Chart type of a stepped chart. The listed chart types should be two-dimensional.

Set the parameters:

NOTE. Marker auto rotate is available only for the Inverse Triangle and the Triangle types.

After executing the operation, markers are displayed for the data series according to the specified parameters.

If required, deselect the Markers checkbox to hide data series markers from the chart.

Data Labels

Data labels contain information about data series or single data points and make it easier to understand a chart.

To display labels for a selected series, select the Data Labels checkbox.

NOTE. Data series label setup is available for series of all chart types, except for waterfall charts.

For details about data label setup see the Data Labels section.

Plotting a Series on a Secondary Axis

A secondary axis is an auxiliary value axis, which can display:

To plot a series on a secondary value axis, select the Plot on Secondary Axis checkbox. After the checkbox is selected, the Value Axis (Secondary) group of parameters is displayed on the parameters panel that is used to set up a secondary axis.

NOTE. Plotting a series on a secondary axis is available for all chart types, except for radar charts, pie charts and waterfall charts.

For details about secondary axis setup see the Chart Axes section.

Trend Line

A trend line is used to visualize data trends and predict their further changes.

The example of a trend line with a one point forward forecast:

To display a trend line, select the Trend Line checkbox.

NOTE. Trend line setup is available only for histograms, histograms with fluctuation intervals, area charts, line charts, mixed charts, scatter charts, bubble charts and stepped charts.

After the checkbox is selected, the trend line parameters setup panel is displayed:

Set the parameters:

Use the Show in Legend checkbox to set up displaying of trend line in the legend. The checkbox is selected by default, and a trend line is displayed in the legend.

To redefine trend line name in the legend, select the Redefine Name in Legend checkbox and set a new line name. It is available only when the Show in Legend checkbox is selected.

Depending on the trend line type selection, additional fields will be available:

Color Scheme

A color scheme is used to determine column color: Increase, Decrease, Total.

To change column color, select the required color in the drop-down palette or set it in the RGB and HEX format.

NOTE. Color scheme setup is available only for waterfall charts.

Visibility of Connecting Lines

To display connecting lines, use the Connecting Lines checkbox. The checkbox is selected by default, connecting lines are displayed. Line color, type, and width are can be set up on the Border panel.

NOTE. Visibility of connecting lines can be set up only for waterfall charts.

See also:

Data Visualization as Charts