Download Excel Workbook
Table of Contents
Change the Axis Units in an Excel Chart
Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set.
If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in your chart.
A great way to overcome this problem is to display the axis units in “Thousands” or “Millions”, thus making your chart much more cleaner.
See how this is done below…
Download workbookAxis-Units.xlsx
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.
