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

Win/Loss Sparklines When you haveĀ  a large data set with positive and negative numbers, a great way to visualize the trend is to add a Win/Loss Sparkline next to your data.That way you or the reader can easily spot the trends and patterns.To enter a Win/Loss Sparkline in Excel you firstly ne...
Clustered Bar Chart: Year over Year Comparison If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014.DO...
How To Make Negative Red Numbers In Excel When you are working with lots of different numbers in Excel, you sometimes want your numbers to stand out by showing them in a negative red number with a minus sign in the front.To do this you need to select your numbers and press CTRL+1 to bring up the Format dialogue box. ...
Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart.For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables.Well you c...