Chart customization
Advanced analytics allows you to customize the display of the chart. The main ways of customization:
- adding grid lines
- adding borders
- axis labels customization
- axis names editing
- changing the axis scale to logarithmic
- displaying entire values in labels
- displaying values for series
- chart colors customization
- secondary axis adding
- displaying two chart types on one graph
- distinct-count measures adding
To customize your chart, click

Adding grid lines
- Go to the
Style tab and select the axis:Value Axis , to display horizontal grid lines.Category Axis , to display vertical grid lines.
- Change the line color, width, and style in sections:
Value Axis > Grid > Major Gridlines , to set the main horizontal grid lines.Value Axis > Grid > Minor Gridlines , to set additional horizontal grid lines.Category Axis > Gridlines , to set vertical grid lines.

Adding borders
You can add two types of borders to your chart:
- Inner border that frames individual graphic elements, for example, columns of a bar chart or sectors of a pie chart.
- Outer border that frames the entire chart along with the axis names and title.
To add an inner border:
- Go to the
Style > Plot Area tab - Specify the fill color, border color and line thickness in the
Background and Border Style section.
To add an outer border:
- Go to the
Style > General tab. - In the
Background and Border Style section, specify the fill color, border color, corner rounding, line thickness, and line style.

Axis labels customization
Axis labels are numbers located along the axes of the chart at an equal distance from each other and allow the user to navigate in the analyzed data. To add labels:
- Go to the
Style tab and select theCategory Axis orValue Axis - Select the number format and the angle of the labels, change the font settings.

Axis names editing
You can edit the axis names in one of the following ways:
- change the name in settings
- change the name when adding a calculation
To change name in settings:
- Go to
Style tab > Category Axis orStyle tab > Value Axis . - Check the
Show Axis Name box in theAxis Name area. - Enter the axis name in the field that appears.
- Change the font (optional).

To change the axis name using a calculation:
- Select the chart and on the
Data tab find the name of the axis you want to change. - Click the name and select
Replace > Add Calculation from the menu. - Enter a new name in the top field and paste the previous measure name in the bottom field (no equal sign required).
- Click
Done . - Select the created calculation as a measure in the measure selection menu.

Changing the axis scale to logarithmic
- Go to the
Settings > Style > Value axis > Axis scale . - Check the
Logarithmic scale box.

Displaying entire values in labels
You can round large numbers. For this:
- Go to the
Style > General tab. - From the
Abbreviate Big Numbers drop-down list, select the type of abbreviation or disable this feature.

Displaying values for series
Value labels are numeric designations that correspond to the values of chart elements. They are needed to visually evaluate the metrics and compare them with each other. To add value labels:
- Go to the
Settings > Style tab. - In the
Value Labels section, set the switch toggle toOn . Labels will be added to each row in the chart.

Chart colors customisation
- Go to the
Data > Colors tab. - Choose a color setting option:
- To color the chart with a single color, choose
Color by > Single Color , then clickSeries Color and choose a color from the palette. - To color the data series in different colors, select
Color by > Field , then select the measure and color palette in thePalette section.
- To color the chart with a single color, choose

Adding secondary axis
When displaying two different measures on the same graph, the numbers can vary greatly. At this scale, the difference between smaller values may not be visible on the graph. To better visualize the change in indicators, use an additional axis:
- Go to the
Style > Series tab and select the series you want to move to the secondary axis. - In the menu of the selected row, select
To the secondary axis checkbox.

Display different types of charts on the same chart
- Go to the
Style tab > Series and select the chart you want to change the type of. - From the
Show Series as drop-down list, select a new chart type.

Adding distinct-count measures
The
Example: You want to analyze data from an in-game store with a lot of purchases to find out how many of each item was sold. To do this, add a column with unique game item numbers as the measure and select the distinct-count as the aggregation type.
To add measure:
- Click the
Edit button, select the chart and go to theData tab. - Click
Add Measure and select theDistinct count aggregation type.

Was this article helpful?
Rate this page
Don’t want to answer
Thank you for your feedback!
Found a typo or other text error? Select the text and press Ctrl+Enter.