Pie of a Pie of a Pie chart [Good or Bad?]
There are some charts that look so stunning and yet confusing. You cant make up your mind whether it tells a compelling story or it is just plain wrong.
Today, let me present you one such chart. I call this Pie of a Pie of a Pie chart.
Thermo-meter chart with Marker for Last Year Value
During a recent training program, one of the students asked,
Thermo-meter chart is very good to show how actual value compares with target (or budget). But how can we add another point for say Last Year value to the chart with out cluttering it.
Something like above.
Sounds interesting? Read on
Sales Analysis Charts in Excel – 78 Alternatives
Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.
Show Details On-demand in Excel [Tutorial + Training Program]
Yesterday, we have seen a beautiful example of how showing details (like distribution) on-demand can increase the effectiveness of your reports. Today, we will learn how to do the same in Excel.
August 2010 – Best Month Ever (and 2 charting tips inside)
Time to stop everything we do and celebrate, for, our little community at chandoo.org had the most fantastic, awesome month ever.
That is right. August 2010 has been the best month since I started chandoo.org. We have broken a majority of previous records in terms of conversations, connections, content and revenues.
In August, we had 17 posts, with 604 comments. We had 178,000 visitors reading 453,000 pages. Our RSS subscriber base grew to 11,917 (it was 5738 an year ago). August has been the best month in-terms of revenues too. We sold highest number of project management templates & excel formula e-books since launch. We had a stellar launch for wedding planner with 22 customers.
Read rest of this post to find statistics about chandoo.org and get 2 charting tips.
Immigrants in Denmark – An Excel Infographic
Faheem (@FaheemH) from Denmark sent me this beautiful infographic depicting various facts about Immigrants in Denmark. Immigrants in Denmark – Excel Infographic: [view high res] How is this Info-graphic made? Faheem used a variety of tricks to create this infographic. Some of the key ideas are, Using text boxes and drawing shapes Using bar charts […]
5 Rules for Making Better Charts (and one fun chart)
Jeff Weir, an alert reader of this blog points me this chart showcasing voice-over artist’s for various Simpson’s characters. I am a hard-core Simpon’s fan, so I naturally wasted quarter-hour looking at the chart. That is when I realize this chart is not only fun, it also teaches 5 valuable lessons on making better charts. Read the rest of this post to find out the five rules.