fbpx
Search
Close this search box.

5 simple rules for making awesome column charts

Share

Facebook
Twitter
LinkedIn

For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.

Tip: Same rules apply for bar charts too.

Rule #1: Start at zero

The first rule is simple. Always start your column charts at zero. When looking at column (or bar) charts, our mind measures height of each column and compares. So, if a column starts at some arbitrary point instead of zero, it can mess with our perception of how each column compares with other. Don’t believe me. See yourself.

Related: What is the most embarrassing charting mistake you made?

Rule #2: Thou shall sort

Sort your columns in a meaningful order. For example, sort them by descending order (of column heights), alphabetical order or chronological order. This will make reading the chart easy.

Sort your chart values in a meaningful order to make it easy to read.

Rule #3: Slap a title on it

Give your chart a meaningful, clear title. Few examples of good and bad titles shown below.

Add a title and caption to your charts Rock star tip: Using smart titles & legends in your charts

Rule #4: Axis & Grid-lines vs. Labels

For most charts you can use data labels instead of axis & grid-lines. This will keep the chart clean.

If you choose to go with Axis and gridlines, then make sure they follow below guidelines.

  • Axis label text should be relatively small & dull.
  • Grid lines & axis line should be dull too.
  • Do not display too many or too little major units on axis. You can change major unit size by selecting axis and pressing CTRL+1 (or axis options pane in Excel 2013).

Try to use labels instead of axis / grid lines. This will clean up your charts a bit.

Rule #5: Too much lipstick and you have a pig

Make sure the formatting (colors, fonts, special effects, backgrounds etc.) of your chart are really subtle and meaningful. If you use too many colors, you end up with a pig. People will then focus on all these colors, fonts instead of actual data.

Always go with simple and easy formatting. Too much formatting leads to gaudy, shallow charts

Few ways to add wow factor to your chart without messing it up:

So there you go. Follow these rules and your column charts will stand tall.

Share your rules for making awesome column charts

While above rules capture the gist of making good looking column charts, there is more to learn and follow. So go ahead and share your rules and tips using comments. Teach us how you make stunning column charts (or bar charts). Post your comments below.

Make charts often? Check out these tips:

If your job involves analyzing & charting data, then check out below tips to learn more.

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

Excel School made me great at work.
5/5

– Brenda

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.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

37 Responses to “5 simple rules for making awesome column charts”

  1. Jon Peltier says:

    Re Rule #2: Alphabetic during should rarely if ever be used. It is arbitrary, and takes away meaning that is conveyed by a more meaningful sort order.

    • JD Hen says:

      I guess if you are going to use a somewhat arbitrary sorting, alphabetic order at least means that you can quickly locate specific columns.

      • Jon Peltier says:

        If you sort alphabetically for easier lookup, you've made a table.
         
        If you want the data to be understood, it's worth spending the time and mental effort to make it readable, and this post covers several ways to do that. Including sorting by an appropriate variable.

        • Deepak says:

          Apart from Sorting, the most important points which i liked is point no.3.

          This gives a quick summary on analysis.

  2. Heather R says:

    Regarding sorting orders - I generally have reports with more than one chart which relate to one another.
    Because of this, I always make sure that whatever order the departments (or whatever I'm measuring) are sorted in the SAME order for each chart. Same thing goes for any colors I am using (if 2010 is red in chart one, it's also red in chart two).

  3. Frank says:

    Rule #5 This is very true. ALWAYS remember your audience. 9/10 people in the room your presenting the charts to aren't going to be savvy with excel, and the message you are trying to get conveyed will be distorted and in the worst case not heard.

  4. Hui... says:

    Any sorting, Rule 2, has to be related to the context of the data and the story it is telling

  5. Nikunj says:

    Whenever I make a chart (not just a column chart, any chart), I always make the fill as 'No fill' and border as 'No Border' using the Format Chart option. Same with the Plot area of the chart using the Format Plot Area options. The default fill in chart and plot area is White. Visually on excel it does not make a difference, but if you were to paste the charts on a PPT, which i usually do, the white fill shows up as a faint border on the slide. Also making it transparent helps in handling on the PPT

  6. ElDullner says:

    Rule 4: Delete the % mark on the axis and add a subtitle "in percent".

    Rule 5 B: When using numbers above 1000 on the axis, just leave the zero's and and x1000 above the axis. The bars.

    In both cases: More space for the most important thing of the chart. The bars.

  7. Pavel says:

    Rule #5
    Hallo all,

    for this is not problem prepare standards in every company (use TPM or other).
    Example use colors in charts:
    Yelow - last year (LY)
    Blue - terget for this year
    Red - results is bad compare to target
    Orange - results is bad compare to target but better than LY
    Green - results is good (compare to target and LY)

    All people know this colors and you haven't problem with presentation all KPI.
    Pavel

  8. Joerg says:

    ...use the bars from left to right for time issues and use it from top to bottom for structural issues like the example above.

    That gives your reader a clear picture and he has not to start to think about the chart from scratch.

    Also direct labeling instead of a legend is very helpful for line or stacked bar charts.

  9. Frédéric says:

    Colors are great but when making charts we often Forget blind color people. Idea for a contest ?

    Otherwise great ideas as usual ! Thanks Chandoo !

    • Heather R says:

      We actually did have a color blind person on our management team - and for her (yes, it was a woman) - I used patterns instead of colors for fill.

      For those who needed the colors (visual learners) - I used colors with the pattern.

      So one range might be a blue cross-hatch, while another was a green dot. Another thing to keep in mind with color impairment is that some people cannot easily distinguish between shades of a color.

      Basically - know your audience, and NEVER expect that the chart can speak for itself. Use labels and have numbers clearly visible in a graph nearby for reference by your users.

    • John G says:

      I have been using CVD-friendly color schemes a lot since a colorblind supervisor came to my facility (CVD = color vision deficiency). I got my color scheme from this website: http://jfly.iam.u-tokyo.ac.jp/color/

  10. […] 5 simple rules for making awesome column charts | Chandoo.org […]

  11. […] 5 simple rules for making awesome column charts | Chandoo.org […]

  12. Nikhil @ MobileJury.com says:

    This is easy to learn creating awesome columns. Thanks a lot buddy.
    I will use this in our excel sheets for sure. Keep updating! Cheers!

  13. This is super super awesome! Thanks again chandoo, these are small thing, but makes a big difference when you actually want to depict the graphs to tell you entire story flawlessly. This is the best excel blog I have ever read and is simple yet on target.

    Looking forward for many more similar easy to go tips.

    Bhushan Sangle. Mumbai. India

  14. Chris Hanson says:

    I am not convinced that rule #1 is absolute. I report weekly on labor utilization (billable time/all time in period). It moves plus or minus about 5 percentage points. One half of a percent is significant.

    However, on a bar chart starting at zero % the difference between say, 76.3% and 76.9% is nearly invisible.

    In order to even see the small percentage % I start at a greater value than 0%. Is there a better way?

  15. Ankit Bansal says:

    Another awesome post. Its really amazing to see you run this whole blog around Excel. There is always so much to explore.

  16. Stephen says:

    Sorting charts is usually a bad idea unless you have error bars or a time series. I can take random data, sort the groups, and hey presto it looks like there is a descending pattern to the data.

  17. Cyndi says:

    On Data labels (see #4 as sample), is there an easy (and nice) way where I can add on additional data labels below the X axis?
    For example, I would like to show the sample size for each department. So, it is like an additional row below the Department Row (X-axis).

    I know i can use text boxes for this, but i have problems aligning all the text bosses so it will look neat.

    Any tips?

    • Jon Peltier says:

      Cyndi -

      Include it in your category labels (the X axis labels). So instead of "Ops", "HR", "Sales", etc, enter "Ops50", "HR42", Sales37", etc. into the cells, where is a line feed, which you get by holding Alt while pressing Return.

  18. […] 5 simple rules for making awesome column charts (2013) […]

  19. My Blog says:

    For hottest information you have to pay a quick visit the web and on the web I found
    this website as a best site for latest updates.

  20. Great post about column charts and this is useful information, thanks
    keep sharing

Leave a Reply