Data Labels

Use the data labels options to show or hide data labels, and to customize data label fonts, colors, formats, and more. The Data Labels options are available for all charts, bubble and heat maps. To learn about shape map data labels, click here.

Formatting Data Labels

Data labels can be adjusted from both the Formatting panel and the Component ribbon.

Formatting Panel

Turn on Data Labels

Data labels are disabled by default. Start by turning them on by selecting the Data Labels checkbox at the top of the panel (purple highlight above). Data labels can also be enabled or disabled from the Component ribbon.

Position the Labels

From the Position drop-down (green highlight above), choose the position of the data labels.

  • Optimized: Pyramid will determine the optimal data label settings.
  • Inside: place data labels inside the chart segments.
  • Outside: place data labels outside the chart segments.
  • Inside Top: (supported for column charts only) place data labels inside the top of each column.
  • Inside Middle: (supported for column charts only) place data labels inside the middle of each column.
  • Inside Bottom: (supported for column charts only) place data labels inside the bottom of each column.
  • Outside: place data labels outside the chart segments.

Label Optimization

  • Optimize Outside Labels: appears when position is set to Optimized or Outside for segment charts only.
  • Allow Labels Overlap: show labels that overlap with each other.
  • Overlap Tolerance: labels with a collision percentage above the given amount will not be shown.

Label Font

Adjust font type, size, and style for the data labels (blue highlight above).

  • Font: change the font type.
  • Size: change the font size.
  • Style: change the font style (bold, italics, or color).
  • Background Color: change the background color for data labels.


Adjust the content of the data labels (yellow highlight above). By default, data labels show the numeric value of each segment, but you can add more information to the labels.

  • Value: set the units for the data labels. Choose Auto to let Pyramid set the units, or select thousands, millions, or billions. Choose Off if you don't want to display units.
  • Series: add the data series to the label (this will correspond to the legend).
  • Category: add the hierarchy category to the label (this will correspond to the categories on the x-axis).
  • Percentage: when working with segment charts and stacked 100% column charts, this option will be enabled instead of Category. Use it to show the segment value as a percentage of the total.

Choose the Data Series

If the report features a legend driven by a hierarchy in the color drop zone, a data series drop down will appear (red highlight above). To apply formatting changes to every series in the report, make changes will the selection is set to Default.

If you want to make changes to a given series only, select the relevant series before applying formatting changes (as in the image below). You can then show or hide data labels for the given series (ref highlight below), and apply any formatting changes as required.

You can further edit each data series using the color formatting capabilities (when selecting Color from the Formatting panel drop-down.

  • Click here to learn more about legends.
  • Click here to learn about series editing.

Data Labels for Stacked Column Charts

Data labels in Stacked Column charts can be displayed in two ways:

If you want to display a label for each segment of the column (highlighted for one column below), select the Data Labels checkbox as above:


Adding Total Labels

If you only want an overall total for each column, leave the Data Labels checkbox unchecked, and instead click the label totals button , then the Show Total Labels checkbox as shown below in the orange box.

The total value will be added to each stacked column as shown below (red circles).


Component Ribbon

Toggle data labels on and off from the Component ribbon: