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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below:You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10.W...
Custom Chart Labels Using Excel 2013 In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative.View the Benchmark Chart using Excel 2013 DOWNLOAD EXCEL WORKBOOKSTEP ...
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...
Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts.This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.From this selection you can show your Chart with or without t...