Ampler Charts lets you set the number format of segment or total labels — decimals, and custom prefixes or suffixes such as a currency sign.
Quick answer: Select the labels (Shift + left-click from first to last), click Number format, and set the decimals or type a custom format such as a $ prefix.
How to use it
Select the labels, then set decimals or a custom format.
- Select the first label, hold Shift and left-click the last label.
- Click Number format and select the desired decimal places.
- Type a custom number format directly in the field, for example a $ prefix.
Pre- and post-fixes can also be added by clicking twice on a label; the values still update automatically.
When to use it
Format the labels to the units and precision the exhibit needs — a currency sign, a percentage, the right decimals — and match them to the axis so the chart reads consistently.
How consultants use it
Labels have to carry the right units and precision, or the numbers are ambiguous. Three habits apply:
- The right units: a currency sign or percentage makes the value unambiguous
- Appropriate precision: decimals are set to what the figures need, no more
- Consistent with the axis: label format matches the axis and the deck
Formatting the labels keeps the numbers clear and correctly denominated.
Tips & best practices
- Add a unit prefix or suffix so labels are unambiguous.
- Keep decimals to what the data needs — excess decimals add noise.
- Match the label format to the axis and other charts.
Availability
Part of Ampler Charts, included in Ampler for PowerPoint and the Ampler Suite, on Windows desktop PowerPoint.
Frequently asked questions
How do you change decimal places on chart data labels?
Select the labels in Ampler Charts, click Number format, and choose the decimal places.
How do you add a currency sign to chart labels?
Type a custom format in the Number format field, such as a $ prefix — or click twice on a label to add a prefix or suffix.
How do you show chart labels in thousands or millions?
Use a custom number format with the unit (e.g. an ‘m’ suffix) and the right decimals, so labels read in the correct magnitude.
Do the labels update if the data changes?
Yes. The values update automatically; the format you set stays applied.