If you've shared your chart online, anyone can see the data behind each bar, column, or line by simply hovering over it with the mouse cursor. However, some charts allow you to display the values permanently inside the chart. This can be useful if you plan on downloading your chart as a static image or a PDF file where interactivity is not supported.
Display values in your chart
- Click on the chart to select it.
- Expand the Chart properties tab in the Settings panel on the right.
- Enable the Show values option.
- In column and bar charts, you can also choose to display the values outside of bars/columns. Enable the Show values outside option in the right sidebar.
- Sometimes the values will not display even when the Show values option is enabled. This happens when there is not enough space to display the values within the bars or columns. In such cases, you need to increase the chart size or decrease the value font size in Fonts - Advanced settings.
- If the values are too crowded on your chart, you can hide the overlapping ones by enabling Hide overlapping values toggle. This feature is available in line charts, and stacked bar and column charts.
- In pie charts, the option to show values is called Show callouts. By default, the callout displays the category name (Callout name option) and the automatically calculated percentages (Callout percentage option). To show the values instead of percentages, disable the Callout percentage option.
- In multiple-axes charts that combine columns with lines, you can choose to show values only on the line or the columns, or both. To enable showing chart values, expand the Chart properties tab and enable Show column values and/or Show line values.
- To change the value alignment in bars and columns, expand the Advanced settings in the Fonts tab. Under the Values font settings, you'll find the buttons to align the values in the middle, at the top, or at the bottom of the columns (right, left, or middle for the bars).