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.

excel reduce huge numbers in charts

To do it in Excel, here is the answer:

a) Select the Y-Axis on the chart. Right click and click on "Format Axis".

excel reduce huge numbers in charts

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).

excel reduce huge numbers in charts

c) The Y-Axis numbers are displayed in selected units (in the current example in Thousands).

excel reduce huge numbers in charts


You can find similar Excel Questions and Answer hereunder

1) How to use flash fill in Excel. How to fill cells very quickly and automatically.

2) Formula converts date to quarter and year in Excel

3) How to create charts in Excel VBA

4) Here the different chart types in Excel.

5) Converting numbers stored as text to numbers via macro in Excel

6) How to use data table function in Excel. It helps you go through various scenario when seeking a goal

7) How to create Pivot table in excel VBA

8) Is it possible to use 2 labels in X-Axis of a chart (like both Month and Date, Date and Day, Date and Shift)?

9) How to follow the changes of variable dynamically with the watch window in Excel

10) What is a methods. Methods are action that can be performed by an object


Here the previous and next chapter