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 WORKBOOK

Axis Units

HELPFUL RESOURCE:

eu_logo_150

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

Share on Google+

Google+

Related Posts

Excel Chart Marker Options The Marker Options within an Excel chart enables you to add different marker types or shapes on your chart to distinguish a data series or its individual data points. To bring up the Marker Options you need to click on your Excel chart and make sure that all the points are sel...
Create a Box and Whisker Chart With Excel 2016 Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977. They show you the distribution of a data set, showing the median, quartiles, range and outliers. The X in the box represents the Mean. ...
Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
Fix Incorrect Formatting Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically. Ever had the scenario where your data is formatted differently? Example: First names starting wit...