Format the values in your data table to control the value formatting in your chart. Modify the formatting for all of your chart labels or select and format specific values independently. Format category labels and measurements to clarify your chart for stakeholders.
Format data labels
The value formatting in the data table for a chart directly affects the formatting of data labels in the chart. You can select and format all of the values in the data table at the same time. You can also select and format specific cells.
Use the value formatting drop-down in the Edit toolbar to apply format options. This will change the formatting for all of the cells selected in the data table and the associated data labels in the chart.
Format measure axis labels
The formatting of the axis labels indicating data measurements is controlled by the formatting of the very first value cell in the table. Change the value formatting of the first cell in the first series to change all of the associated axis labels.
To format measure axis labels:
- 1
Select a chart.
- 2
Go to Chart Properties .
- 3
Choose the Formats tab.
- 4
Select the axis labels in the chart.
- 5
Toggle the Override Inherited Format option.
This gives you control over how your measure axis labels are formatted, regardless of what value format is applied to the chart data table values.
You can set a number of options for the value formatting of the measurement axis labels. These options include a custom prefix or suffix, leading zeros, thousands separators, and more.
Format category axis labels
To format your category axis labels:
- 1
Select the category labels in the data table.
- 2
Use the options in the Format tab of the Chart Properties panel.
What's next