fbpx

Are you making Blow charts? [charting tips]

Share

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Here is a simple question you should ask when you set out to make a new chart.

Are you making a BLOW chart?

Blow? what blow.. you may ask. BLOW stands for Blinding Light of Obvious Wisdom. In other words, a blow chart tells nothing. It is there just for the heck of it.

I remember cramming my summer internship report with tons of charts just so that it would look like a heavily analyzed output. There were so many blow charts. But later I realized the mistake and started using charts only when they enable readers to do some analysis or provide some information.

What is your take on blow charts? Have you ever made them or you always avoid them?

PS: while you are at it, check your chart’s underwear as well.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Share this tip with your colleagues

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

Chandoo is an awesome teacher
5/5

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

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

20 Excel Templates

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

Extract words from sentence using FILTERXML - formula tip

#awesome trick – Extract word by position using FILTERXML()

This is CRAZY!!!. I stumbled on a weird use for FILTERXML() while reading a forum post earlier today. So I couldn’t wait to test it. I am happy to share the results.

Say you have some text (sentence / phrase / keyword etc.) in a cell and you want to extract the nth word. Unfortunately Excel doesn’t have SPLIT() formula. So we end up writing obscenely long array formulas or use gazillion helper columns.

Here is the super sneaky trick. Use FILTERXML() instead.

2 Responses to “Are you making Blow charts? [charting tips]”

  1. Jon Peltier says:

    Chandoo -

    What's the difference between a BLOW chart and a SUCK chart? Other than BLOW being an acronym?

  2. Chandoo says:

    @Jon... nothing... they both suck...

Leave a Reply