Bar chart 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 Positions and Size

1.1 Position Chart Area

1.2 Position Plot Area

2 Appearance

2.1 Chart Background

2.2 Plot Background

3 Legend

3.1 Background

3.2 Symbols

3.3 Labels

3.3.1 Character

3.3.2 Paragraph

3.3.3 Shadow

3.3.4 Background

Data

4 Bars

4.1.1 Multi-Series: Grouped

4.1.2 Multi-Series: Stacked

4.1.2.1 Transition

4.1.3 Multi-Series: Overlay

4.2 Distribution

4.3 Shadow

4.4 Background

5 Data Marks

5.1 Symbol

6 Data Labels

6.1 Smart Labels

6.2 Number Format

6.3 Character

6.4 Paragraph

6.5 Shadow

6.6 Background

Axes and Grid

7 X Axis

7.1 Axis > Type: Numerical

7.2 Number Format

7.3 Line

7.4 Major Ticks and Grid

7.5 Minor Ticks and Grid

7.6 Labels

8 Y Axis

8.1 Axis > Type: Categorical

8.1.2 Line

8.1.3 Ticks and Grid

8.1.4 Labels

8.2 Axis > Type: Numerical

8.2.1 Number Format

8.2.2 Line

8.2.3 Major Ticks and Grid

8.2.4 Minor Ticks and Grid

8.2.5 Labels

 

8.3 Axis > Type: Datetime

8.3.1 Line

8.3.2 Major Ticks and Grid

8.3.3 Minor Ticks and Grid

8.3.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-Bar-Binding-First-row-are-headings
Data is in Sets the way data is structured: in rows or columns. Helpcenter-Properties-Bar-Binding-Data-is-in

Back to top

 

Series>

Name

Text field to name the Series. By default, it is set to “New Series n”. 

This name will be used for Direct labels in Line charts.

Helpcenter-Properties-Bar-Chart-Binding-Name
Y

Y-axis is used for binding categories. Categories can be of 3 types:

  1. Categorical
  2. Numerical
  3. Datetime
Default is categorical. You can change the data type in the Formatting tab. To visualize correctly make sure to select the correct type in, Styling > Axes and Grid > Y Axis > Type
Helpcenter-Properties-Bar-Chart-Binding-Y

 

 

One or more empty cells in the data will give the following result::

  1. Categorical data type: An empty category and corresponding label is added. Values of multiple empty categories will be added into one.
  2. Numerical data type: No bar is rendered. No data label is plotted A warning appears:
    “Empty values found where number values were expected. Data is ignored” 
  3. Datetime data type: No bar is rendered, even if there is corresponding data bound to the other axis. No data label is plotted. Datetime labels between the start and end date are added though. A warning appears:
“Empty values found where datetime values were expected. Data is ignored”

1

helpcenter-properties-bar-chart-binding-x-categorical-empty-cells

2

helpcenter-properties-bar-chart-binding-x-numerical-empty-cells

3

helpcenter-properties-bar-chart-binding-y-datetime-empty-cells

X The X-axis is used for binding numerical data which will be visualized by the length of the bar. Helpcenter-Properties-Bar-Chart-Binding-X
  If there are empty cells in the column (row) bound to the X-axis, the bar won’t be plotted, no data label is added (as opposed to a zero in the data), but the corresponding category will still appear. helpcenter-properties-bar-chart-binding-y-categorical-empty-cells
Color Allows binding color to column (row). For more details see How to optimally use colors in bar charts

Colors can be presented directly as HTML colors, HEX, RGB, or CMYK values. To use direct coloring the color of bars should be set to “None” under Styling > Data > Bars > Color.
Helpcenter-Properties-Bar-Chart-Binding-Color
Data Label Adds the content of a bound column (row) instead of data labels Helpcenter-Properties-Bar-Chart-Binding-Data-Label

 

Styling Tab

DATA

Bars>

Chart Orientation Defines the X-axis as horizontal or vertical. Helpcenter-Properties-Bar-Chart-Bars-Chart-Orientation
Color Sets the color of the bar. Helpcenter-Properties-Bar-Chart-Bars-Color
Stroke

Sets the color and weight of the stroke.

You can apply a dashed stroke or change the type of stroke placement by clicking the cogwheel.

Helpcenter-Properties-Bar-Chart-Bars-Stroke
Stroke > Type Allows to use two types of stroke placement: 
  • Inner (the stroke is placed inside the bars)
  • Center (the center line of the stroke is placed on the bar border)
Helpcenter-Properties-Bar-Chart-Bars-Stroke-Type
Stroke > Dashed Line

Allows changing the length and gaps between the dashes.

Helpcenter-Properties-Bar-Chart-Bars-Stroke-Dashed-Line
Horizontal Rounding Sets the horizontal rounding of the bar. Becomes visible if the vertical rounding value is above zero. Helpcenter-Properties-Bar-Chart-Bars-Horizontal-Rounding
Vertical Rounding Sets the vertical rounding of the bar. Becomes visible if the horizontal rounding value is above zero. Helpcenter-Properties-Bar-Chart-Bars-Vertical-Rounding
Round All Corners Applies rounding to all corners of the bar. Helpcenter-Properties-Bar-Chart-Bars-Round-All-Corners
Sorting

Set the type of bar sorting.


There are 4 options available:

  1. None
  2. Ascending
  3. Descending
  4. Reverse
Helpcenter-Properties-Bar-Chart-Bars-Sorting
Max Number of Bars Set the number of bars that will be displayed. No changes in data are applied. Helpcenter-Properties-Bar-Chart-Bars-Max-Number-of-Bars

Back to top

 

MULTI-SERIES MODE: GROUPED

Series Order

Sets the order of bars inside a group. Ordering is based on a sum of all values from each series. 


There are 5 options available:

  1. None
  2. Ascending
  3. Descending
  4. Insideout
  5. Reverse
Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Grouped-Series-Order
Spacing

Sets the space between bars within the same group



Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Grouped-Spacing

Back to top

 

MULTI-SERIES MODE: STACKED

Stack Type

Sets the stack type:

  1. None
  2. Percentages
  3. Diverging
Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Stacked-Type
Series Order

Sets the order of bars inside of the stack. Ordering is based on a sum of all values from each series. 


There are 5 options available:

  1. None
  2. Ascending
  3. Descending
  4. Insideout
  5. Reverse
Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Stacked-Series-Order
Round All Corners of Stack Round all corners of a stack as if it’s one bar Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Stacked-Round-All-Corners-Of-Stack

Back to top

 

TRANSITION

Transition

Adds a transition line or/and area between bars of the same series (stack)

 
Type

Sets the transition type: 

1. Linear

2. Curved

Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Stacked-Transition-Type
Fill

Sets the color of the transition. Possible options are:
1. None

2. Link

3. Solid

4. Palette

5. Gradient

Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Stacked-Transition-Fill
Stroke

Sets the color, weight, and dashed line options of the stroke of the transition lines.

Helpcenter-Properties-Bar-Chart-Multiseries-Mode-Stacked-Transition-Stroke

Back to top

 

OVERLAY

Overlay

Option to overlay one or more series on top of others. This section defines the generic behavior of those overlay series.

Only applicable in case Styling > Series > Overlay Series is enabled for one or more series. 

 
Overlay Mode

Sets the way the overlaid bar and/or marks will be placed:
1. On Top

2. Grouped

3. Stacked

Helpcenter-Properties-Bar-Chart-Multiseries-Overlay-Mode
Bar Size Sets the relative width of the overlaid bar relative to the main underlying bar. Helpcenter-Properties-Bar-Chart-Multiseries-Overlay-Bar-Size
Outer Padding Available only when Grouped Overlay Mode is selected. Sets the padding between grouped overlaid bars and the main bars. Helpcenter-Properties-Bar-Chart-Multiseries-Outer-Padding

Back to top

 

DISTRIBUTION

Width Sets the width of the bar in absolute or relative values Helpcenter-Properties-Bar-Chart-Distribution-Width

Back to top

 

SHADOW

Shadow

Available in Datylon web app only.


Adds shadow to a given element. Color, Xand Y offset and Blur are available for editing.
Helpcenter-Properties-Bar-Chart-Shadow

Back to top

 

BACKGROUND

Color Sets the color of the background bar Helpcenter-Properties-Bar-Chart-Background-Color
Stroke

Sets the color and weight of the stroke of the background bar

You can apply a dashed stroke by clicking the cogwheel.

Helpcenter-Properties-Bar-Chart-Background-Stroke
Horizontal Rounding Sets the horizontal rounding of the end of the background bar. Becomes visible if the vertical rounding value is above zero. Helpcenter-Properties-Bar-Chart-Background-Horizontal-Rounding
Vertical Rounding Sets the vertical rounding of the end of the background bar. Becomes visible if the horizontal rounding value is above zero. Helpcenter-Properties-Bar-Chart-Background-Vertical-Rounding
Round All Corners Applies rounding to all of the corners of the background bar. Helpcenter-Properties-Bar-Chart-Background-Round-All-Corners
Shadow

Available in Datylon web app only.


Adds shadow to a given element. Color, Xand Y offset and Blur are available for editing.
Helpcenter-Properties-Bar-Chart-Background-Stroke copy 3

Back to top

 

Data Marks>

Anchor Point

Sets the placement of an anchor point of the data mark:

  1. Start
  2. Center
  3. End
Helpcenter-Properties-Bar-Chart-Data-Marks-Anchor-Points

Back to top

 

Data Labels>

Anchor Point

(can be applied only if Smart labels are turned off)

Sets the reference point for label alignment and offset properties. There are 5 options available:

1. Start

2. Center

3. End

4. Positive Side

5. Negative Side

Helpcenter-Properties-Bar-Chart-Data-Labels-Anchor-Point
Horizontal Alignment Aligns the label left, centered, or right relative to the data point or relative to the data mark anchor if data marks are shown. Helpcenter-Properties-Shared-Labels-Horizontal_Alignment
Vertical Alignment Aligns the label top, center, or bottom relative to the data point or relative to the data mark anchor if data marks are shown. Helpcenter-Properties-Shared-Labels-Vertical_Alignment
Horizontal Offset Sets the position of the label horizontally. Enter a positive value to move to the right. Enter a negative value to move to the left. Helpcenter-Properties-Shared-Labels-Horizontal_offset
Vertical Offset Sets the position of the label vertically. Enter a positive value to move up. Enter a negative value to move down. Helpcenter-Properties-Shared-Labels-Vertical_Offset
Rotation

Rotates the label around the anchor point.

A positive value rotates counterclockwise. A negative value clockwise.

Helpcenter-Properties-Shared-Labels-Rotation
Prefix

Adds a prefix to all legend labels.

Consecutive spaces are ignored. 

Helpcenter-Properties-Shared-Labels-Prefix
Suffix

Adds a suffix to all legend labels.

Consecutive spaces are ignored. 

Helpcenter-Properties-Shared-Labels-Suffix
Hide Zero

Hides the label if the corresponding value is 0

Helpcenter-Properties-Bar-Chart-Data-Labels-Hide-Zero

Back to top

 

SMART LABELS

Location

(Smart labels override left and right position alignment and paragraph alignment)


Places data labels to one of the following relative positions:

  1. Inside Start
  2. Outside Start
  3. Center
  4. Inside End
  5. Outside End
Helpcenter-Properties-Bar-Chart-Data-Labels-Smart-Labels-Location
Overflow

Sets one out of 3 options when an inside start or end label is larger than the bar: 

  1. Show
  2. Hide
  3. Outside
Helpcenter-Properties-Bar-Chart-Data-Labels-Smart-Labels-Overflow
Overflow Color Sets the color of an overflow label when the “Outside” option is selected. Helpcenter-Properties-Bar-Chart-Data-Labels-Smart-Labels-Overflow-Color

Back to top