Welcome to Pointy Haired Dilbert
A very warm, cuddly and hugsy welcome to Pointy Haired Dilbert. I am happy to know that you are reading this. This is a blog about YOU becoming successful. It is all about understanding your data, making your charts better and improving the way you work using excel. Read this post to know more about this site.
Intraday Candlestick Charting [Stock Charts]
Gene asks me in an email, “I’m trying to graph candlestick charts in Excel for 10 minute candles. Excel seems to allow daily only with its stock templates. Can you point me to any resources for creating intraday candle charts?”. Of course, you can create intraday candlestick charts just the way you would create normal candlesticks, just change the axis options once you are done. Read the post to find more.
A Good Chart is a Story [Charting Principles]
A good chart tells a story. Here is a fantastic example of what a good chart is. The chart itself is very simple and easy. But it brilliantly juxtaposes two interesting pieces of data : Obesity rates in countries and Time spent eating per day, to tell a story.
Analyzing Search Keywords using Excel : Array Formulas in Real Life
Jarad asks me in an email “how word frequency can be generated from a range of cells using excel formulas?” This got me thinking and lead to this post, where we learn how to calculate word frequency using array formulas and use it to analyze a bunch of search keywords.
and the Winner is…
The winner for our first visualization contest is decided. Curious? Read on…
How Many Bubbles are Too Many Bubbles?
In How Many Links are Too Many Links, O’Reilly radar shows us this unfortunate bubble chart. Read the rest to see why the chart is unfortunate.
Market Segmentation Charts using Conditional Formatting
Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So here comes market segmentation charts or marimekko charts using,