reduce huge numbers in charts in Excel

Q47. My Y-Axis numbers are huge (in millions) - can I change the way that these numbers are displayed in Y-Axis so that they do not take up chart space (and also avoid being a distraction)?

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 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 excel excel reduce huge numbers in charts

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

excel excel excel excel reduce huge numbers in charts


You can find similar Excel Questions and Answer hereunder

1) How can I add a WorkSheet and name it as required using VBA?

2) How can I shade alternate rows in color using VBA to make it easier to read voluminous data running into hundreds of rows?

3) How can I avoid a gap in a line chart for missing data?

4) How to add a link in a sheet to another sheet

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

6) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

7) How can I export a chart as a gif file?

8) How can I remove all nonprintable characters from text?

9) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

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

11) Vba to return week numbers in Excel

12) Formula converts date to quarter and year in Excel

13) How can I convert Column numbers into Column names for use in range definition?

14) How can I list all files in a folder using VBA?

15) How can I hide Formula Bar and Headings using VBA?