Reader Poll: Should the axis for bar charts always start at zero?

Share

Facebook
Twitter
LinkedIn

It all began with my Excel Dashboard Tutorial – Making a dashboard with player statistics. I have used bar charts with axis whose minimum is not zero, to create a dramatic effect in the charts. See below:

excel-barchart-rule-breaking

Jon Peltier commented saying that,

Rule #1: Bar and column chart value axes should start at zero. Since the lengths of bars and columns represent their values, starting at a position other than zero will lead to a misleading display.

As always Jon raised an excellent point. I liked it so much that I wanted to get your opinions on this axis scaling issue.

What do I think about this visualization rule ?

First the positive points about the rule:

  • If you start axis at non-zero values, it gives a wrong impression about the data. In my example above you might end up thinking the top value is actually 10 times that of bottom value.
  • The rule helps easy interpretation of data, since everything starts at zero.


Now the negative points about the rule:

  • Not all data starts at zero (like the above with values ranging from 8000 to 12000). So when you create a bar chart for the data (why only bar charts, because they are easy to make and read) often you end up creating charts from which making out any analysis could be slightly difficult
  • Breaking this rule helps in creating dramatic effect on your charts, one of the reasons we use them. Often when you use data with narrow range, creating dramatic effect could be difficult. Axis adjustments can help (you may want to try logarithmic axis scale as well)

Finally, I think this rule can be broken as long as we have right data and make alternative arrangements (like adding data labels) to ensure correct interpretation. Since this is a standard people have come to expect, it is better to make it clear to your audience about the axis range.

What do you think about the charting rule: Bar and column chart value axes should start at zero.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

One Response to “Loan Amortization Schedule in Excel – FREE Template”

  1. Ag says:

    The balance formula as given doesnt seem to work on my excel

Leave a Reply