Scatter plot properties

Below you will find in-depth user information about each property, what it does and how it can be applied

Many properties in the DATA section can be set overall for the whole chart, but also separately on the data point level. See data point styling for more details.

Binding Tab


1 Dataset

2 Series

Styling Tab


General

1 Position and Size

1.1 Position Chart Area

1.2 Position Plot Area

2 Appearance

2.1 Chart Background

2.2 Plot Background

Data

3. Data Marks

3.1 Symbol

4. Data Labels

4.1 Number Format

4.2 Character

4.3 Paragraph

4.4 Shadow

4.5 Background

Analysis

5 Trendline

Axes and Grid

6 Axis > Type: Categorical Axis

6.1 Line

6.2 Ticks and Grid

6.3 Labels

7 Axis > Type: Numerical Axis

7.1 Number Format

7.2 Line

7.3 Major Ticks and Grid

7.4 Minor Ticks and Grid

7.5 Labels

8 Axis > Type: Datetime

8.1 Line

8.2 Major Ticks and Grid

8.3 Minor Ticks and Grid

8.4 Labels

 

Binding Tab

Dataset>

First row (column) are headings

When enabled, the first row (column) of the dataset are headings.


When disabled, the first row (column) of the dataset is included in the data range.

helpcenter-properties-scatter-plot-binding-first-column
Data is in Sets the way data is structured: in rows or columns. helpcenter-properties-scatter-plot-binding-data-is-in

 Back on Top

Series>

Name Text field to name the Series. By default, it is set to “New Series n”. In the Scatter Plot, only one series is available. helpcenter-properties-scatter-plot-binding-name
X, Y Used to bind the data to the X, Y position of the data mark. The bound column/row can represent categorical, numerical, or datetime values. helpcenter-properties-scatter-plot-binding-x-y
 

One or more empty cells will give the following result:

  1. Categorical data type: An empty category is added. Values of multiple empty categories will be added into one category. 
  2. Numerical data type: No data point is rendered. No data mark is plotted.
    A warning appears:
    “Empty values found where number values were expected. Data is ignored” 
  3. Datetime data type: No data point is rendered. No data mark is plotted.
    A warning appears:

“Empty values found where datetime values were expected. Data is ignored”

helpcenter-properties-scatter-plot-empty-cells-numerical

helpcenter-properties-scatter-plot-empty-cells-categorical

 

Size Used to bind the data to the size of the data mark. The bound column/row should contain only numerical values helpcenter-properties-scatter-plot-binding-size
Color

Used to bind the data to the color of the data mark. The bound column/row can represent categorical, numerical, or datetime values. By default, it is formatted as a categorical value. The type of data can be adjusted in the Formatting tab.


Colors can be also presented directly as HTML colors, HEX, RGB, or CMYK values. More on that in a specific article. To use direct coloring the color of data marks should be set to “None” under Styling > Data > Data Marks > Color.
helpcenter-properties-scatter-plot-binding-color

Stroke Color

Used to bind the data to the stroke color of the data mark. The bound column/row can represent categorical, numerical, or datetime values. By default, it’s formatted as a categorical value. The type of data can be adjusted in the Formatting tab.


Colors can be also presented directly as HEX, RGB, or CMYK values. More on that in a specific article.
helpcenter-properties-scatter-plot-binding-stroke-color
Icon Used for direct binding. Data should contain the naming of an icon type. Possible values are listed in this article. helpcenter-properties-scatter-plot-binding-icon
Label Used for direct binding. Data should contain the text for the corresponding data mark. helpcenter-properties-scatter-plot-binding-data-labels

 Back on Top

 

Styling Tab

DATA

Data Marks >

Chart Orientation Defines the X-axis as horizontal or vertical. Helpenter-Properties-Scatter-plot-Chart-orientation
Max Size Set the size in width and height of the data mark with the highest value or to the Max Value if set. Helpenter-Properties-Scatter-plot-Max-size-
Min Size
(appears only when "Use Absolute Values" is turned off.

Set the size in width and height of the data mark with the lowest value or to the Min Value if set.
Note that in this case, the proportion between the bubbles does not represent the proportion between the data values. 

Helpenter-Properties-Scatter-plot-Min-Size

Max Value Sets the maximum value of the range that will be represented by the sizes of bubbles. It should be equal to or bigger than the highest value from the data range. Helpenter-Properties-Scatter-plot-Max-value
Min Value Sets the minimum value of the range that will be represented by the sizes of bubbles. It should be smaller than the lowest value from the data range. Helpenter-Properties-Scatter-plot-Min-Value
Use Absolute Values All the values from the data range are taken modulo. Meaning that f.e. 50 and -50 bubbles will look the same. Helpenter-Properties-Scatter-plot-Use-Absolute-Values
Small Marks On Top

When disabled, the marks are placed in order of appearance in the data, so the first line in the data is the first placed mark.

When enabled, marks are placed relative to the size of the mark, smaller marks move to the front, bigger to back.

Helpenter-Properties-Scatter-plot-Small-on-top

 Back on Top

CONNECTOR

Connector Sets the color, weight, and dash properties of a line that connects all the data marks.

Data marks are connected in the same order as presented in the data.
Helpenter-Properties-Scatter-plot-Connector

Back on Top

ANALYSIS

Trendline >

Stroke Sets the color and weight of the line.

Helpenter-Properties-Line_chart-Line-Stroke-Color-Width

Stroke >
Cogwheel >
Cap
Sets the type of the line cap. There are two types available: Butt and Round Helpenter-Properties-Line_chart-Line-Stroke-Cap
Stroke >
Cogwheel >
Dashed Line
Applies a dashed stroke line when a number placed into Dash field.
If no value added to Gap field the value from a Dash field applies as a Gap value.
Helpenter-Properties-Line_chart-Line-Stroke-Dash
Type

Sets the type of the of the function that will be used to draw the trendline:

1. Linear
2. Logarithmic
3. Exponential
4. Power

Helpenter-Properties-Scatter-plot-Trendline-Type

Back on Top

CALCULATION RANGE 

X Min Sets the first value of the range that the trendline will be based on.

By default it's the lowest value in the dataset.
Helpenter-Properties-Scatter-plot-Trendline-Calculation-Range

 

X Max Sets the last value of the range that the trendline will be based on.

By default it's the largest value from the dataset.

Back on Top

DISPLAY RANGE

X Min

Sets the first value of the trendline that will be visualised. Doesn't affect the calculation range.

By default it's the lowest value from the dataset.

Warning: The display range can be extended beyond the calculation range, and as such creates only a graphical prolongation of the regression line.

Helpenter-Properties-Scatter-plot-Trendline-Display-Range

 

X Max

Sets the last value of the trendline that will be visualised. Doesn't affect the calculation range.

By default it's the largest value from the dataset.

Warning: The display range can be extended beyond the calculation range, and as such creates only a graphical prolongation of the regression line.

Back on Top