All articles with 'Charts and Graphs' Tag

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 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.

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.

The winner for our first visualization contest is decided. Curious? Read on…

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.

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, conditional formatting.

As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel

Michael Anderson, a web designer has posted this delicious looking visual resume. While the resume looks stunning at a glance, a closer inspection reveals that you cant really make any valuable conclusions about Michael’s past experience and qualifications. Of course if the purpose of this resume is to show that he is a fabulous designer, then the resume definitely achieved that.
What is your opinion on this type of resume data visualizations ?

This weekend, let us talk … umm… charts. I want to know if you absolutely make sure your charts look good every time you sent them out to someone. I do this most of the time.

How do you sex up your charts?

Stacked bar charts are a popular way to depict 2 more series of related data, like sales of 2 products.But there are several ways to stack the bars in a bar chart. Here is a list of 6 ways to stack them

9 charting tricks you can use to make your pie charts likable

Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.

A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.

After a really long wait finally I have used … Excel 2007 (drum roll) and contrary to what many people think, I have found Excel 2007 to be a very well designed piece of software. Of course there are various issues with it and I am sure folks at MS are working on them so that next versions of MS Office are much more pleasant and simpler to use.

I wanted to share 10 wow factors in Excel 2007 that may convince you to try it.

Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and smarter.