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

Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization: Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this example I show you how easy it is to insert a His...
Create a Pareto Chart With Excel 2016   Pareto Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are the most common. A Pareto chart, also called a sorted histogram, is a column...
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...