Reduce huge numbers in charts in Excel
For example, in the chart below, since the numbers are huge the Y-Axis values that are displayed take up disproportionate screen space and are also a visual distraction.
To do it in Excel, here is the answer:
a) Select the Y-Axis on the chart. Right click and click on "Format Axis".
b) Under "Axis Options", against "Display units" field, select the appropriate units for data as needed (in the current example (Thousands) is the option selected).
c) The Y-Axis numbers are displayed in selected units (in the current example in Thousands).