5.7. Inline charts

Analytics+ provides data visualization at every step. You can insert inline charts in tables to visualize your measures. The data table supports win-loss charts, lollipop charts, and waterfall charts.

1. Inserting a chart

With Analytics+, you can insert a chart in a single click. All you need to do is, select the measure and choose the type of chart required for your data.

Inserting a chart

2. Configuring a chart

You can customize the chart by configuring the canvas and data labels. Select the column containing the chart - the configure button gets enabled.

Canvas and data label configuration options for inline charts

2.1. Canvas

You can use the options in canvas settings to set the appearance and styling for the chart.

i) Fill pattern

You can set the fill pattern to any of the three IBCS notations: Solid, Hatched, or Outlined.

Fill pattern

ii) Positive/Negative

You can set the color scheme for positive and negative values.

Setting the color scheme

iii) Padding

You can adjust the spacing between bars by setting the padding - it is set to 0 by default. In the example, notice how the spacing between the bars has increased on increasing the padding.

Padding between bars

v) Flip column

Enable the Flip column option to create a mirror image of the chart.

Flip column option

vi) Reset Canvas

You can click on this button if you want to remove all custom configurations and reset to default settings.

2.2. Data label

You can customize, enable, and disable data labels.

i) Data label

The data label checkbox needs to be ticked for data labels to be displayed. Uncheck to remove data labels.

Data labels disabled

ii) Bar overlap

When this property is enabled, the data labels will be superimposed on the bar. By default, this option is not enabled and the data labels are displayed next to the corresponding bar.

Bar overlap

iii) Value display

You can choose to display the actual value, the percentage with respect to the total, or both.

Value display

3. Removing a chart

Click on the button with the 1.2 symbol to remove an inline chart.

Removing a chart

Next, we'll look at manually setting the width for columns.