Pinterest Pixel

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... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Change the Axis Units in an Excel Chart | MyExcelOnline

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…

Change the Axis Units in an Excel Chart | MyExcelOnline
Download workbookAxis-Units.xlsx

 

HELPFUL RESOURCE:

Find Blank Cells In Excel With A Color

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Change the Axis Units in an Excel Chart | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!