3.6. Data label display
Last updated
Last updated
You can determine the number of data labels to display in your charts and customize the appearance of the data labels from the settings side pane. You can also configure a percentage to display outlier values. Let's look at these options in detail.
Data label settings can vary based on the chart type.
You can define the number of data labels to render from options like All, None, Min+Max, First+Last, Nth label, etc. For Nth label, an additional Interval option is enabled. You can specify the interval between displaying labels. In the example, we've assigned an interval of 3, which means every 3rd bar will have a data label.
Data labels will not be displayed if the data categories are too close to each other and the data label cannot fit in the available space.
You can customize the variance labels if you have charts with comparative measures for which the variance has been plotted. Similar to value display, you can choose from options like All, None, Min+Max, First+Last, Nth label, etc.
You can display the data points that deviate from the overall trend or average value by selecting the outlier option. Use the Outlier percentage textbox to define a threshold for an outlier based on percentage deviation i.e. if the difference between two consecutive data labels is more than the specified threshold, the point will be plotted as an outlier. You can also choose a color to highlight the outlier values - in this example, we have highlighted the outliers in red.
You can display tooltip measures along with the data labels by selecting the measures from the dropdown.
You can set the position of the data labels with respect to the chart. You can choose from options like Outside, Inside - Top, Inside - Center, Inside - Bottom.
This option applies only to bar charts.
When the data labels are rendered inside the bars, you can specify the orientation.
When the bar overlap option is enabled, data labels will dynamically be plotted inside the bars on canvas resize, thus giving maximum space on the canvas to plot the chart. In the combo chart, notice how some of the Sales data points are displayed inside the bar.
Enable this option to display data labels even if they overlap each other.
Enable this option to display data labels even if they exceed the allotted space.
Enabling this property ensures that the data label color contrasts the chart color and the data labels are clearly visible. The label color is set to black when this property is disabled.
The contrast color option can be enabled only when Display settings > Canvas > Auto color is turned off. When auto color is enabled, the font color is automatically set to contrast with the background.
You can set a custom font color, specify the size, and whether the font should be bold/italicized.
Custom font colors are enabled only when the Contrast color option is disabled.
You can configure the offset position of the data labels. Positive offsets will move the label downwards and negative offsets will move it upwards.
Offsets can be in the range of -100 to 100.
You can assign a background color for data labels. We have set the background color to grey in the example.
You can tailor the data labels for each measure when you plot line charts. Notice how the data labels for each of the measures is rendered based on the individual configurations.
