0

I have a PivotChart in Excel 2016 that has dollar amounts as the x-axis.

enter image description here

Currently, the labels are formatted as full numbers. Example: $1,000,000.

Is there a way to format the labels by replacing the zeros with an "M" for millions? Example: $1M.

For bonus points, is there proper terminology to describe this technique? If so, feel free to suggest a better title. It'd be good to use a title that people can find when googling this issue.

Improve this question

1 Answer 1

Reset to default
1

Use this custom numbering format in the Format Axis options: $#,##0,,"M".

enter image description here

enter image description here

Source:

LinkedIn Learning (Paid) - Excel PivotTables: Mastering PivotTables and PivotCharts - Designing Interactive Dashboards video (7:52)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .