All articles with 'charting principles' Tag
There is nothing awesome about flu. In fact, it is anti-awesome if you have flu. I have been fortunate enough not to get it ever (it is another story that I have cold almost 364 days of an year).
Don’t worry if you are afraid of it, Folks at Google are not letting you down. They are using google search terms to predict flu trends and present the information in a beautiful chart.
Today I want to tell you why this particular chart on flu trends made by Google is awesome…Continue »
Jon Peltier can stand on his roof and shout in to a megaphone “Use Bar Charts, Not Pies”, but the fact remains that most of us use pie charts sometime or other. In fact I will go ahead and say that pie charts are actually the most widely used charts in business contexts.
Today I want to teach you a simple pie chart hack that can improve readability of the chart while retaining most of the critical information intact.Continue »
Over the weekend I spent some time to update the Excel Dashboards page. It now features more articles, downloads and resources for those of you making Excel Dashboards. Go ahead and check out the page here and let me know your feedback.
Moving on to this weeks excel and charting links worth checking.Continue »
This week’s poll is very simple. What is the the most embarrassing charting mistake your made?
For me it has to be that one time when I made a sports dashboard using excel. I have adjusted the axis scale of a bar chart so that my favorite cricket player (Sachin Tendulkar, who else?)’s records are emphasized. In a matter of minutes I have received several comments from all over world pointing out the mistake. Even though, the intention was to highlight the achievements of master blaster, the axis adjustment was obviously a mistake.Continue »
Two charting principles we hear all the time are,
- Sort your data in a meaningful order before plotting it.
- Show only relevant information, not everything – because un-necessary information clutters the chart.
Today we will learn a dynamic charting technique that will mix these two ideas in a useful way. I call this a Top X chart.Continue »
Yesterday while checking my website analytics reports on Google analytics site, I have noticed a new beta feature called “Intelligence”. Out of curiosity I clicked on it. It took me to a an intelligence alert dashboard. Ok, lets just back up for a minute and understand what “intelligence dashboard” is before moving on. In the [...]Continue »
Yesterday I read about interaction plots on junk charts where he points out the merits of an interaction plot. Interaction plots show interaction effects between 2 factors. For eg. you can show how your product sales have changed between year 1 and year 2 using an interaction plot like the one shown aside.Continue »
Ever since I was a child, I was fascinated by Paris (and Eiffel Tower). Recently, I had opportunity to visit Paris, albeit for just a few hours (I had a 12 hour lay-over in Paris between flights). I went to see the Eiffel Tower and it looked just as beautiful and majestic as it did in my imaginations.
During my visit to Eiffel tower, I took the stairs to 2nd floor and along the way they have a handful of visualizations explaining the tower. I found them quite interesting and well made. Here, I have listed down 4 simple, yet very effective visualization lessons for all of us.Continue »
Nothing like a weekend making fun of something worthless. So we will pick on some of the plump, overloaded and visually disgusting pie charts featured on various extremely popular websites. As a bonus, you get to see my hand-drawn pie chart on the usage of pie charts.Continue »
Yesterday we have posted how to use excel combo charts to group related time events. Today we will learn how to change the event grouping dynamically using form controls.
This effect can be easily achieved with a cup of coffee, one combo box form control and the good old IF formula. Read more to learn how to do this.Continue »
In his latest book, Now You See It, on pages 165 and 166 of the book, Stephen Few discusses how grouping related time intervals can facilitate analysis of data. As an illustration he explains that when viewing data of daily website visits, it helps in separating weekdays and weekends to differentiate expected traffic during these periods. The use of this technique would make it easier for the analyst to identify any anomalous movement in ether the weekend or the week day.
Fortunately excel combo charts can help you do that. In this guest post, Paresh explains to us how to do this.Continue »
We talk alot about making better charts and perils of bad charts here.
I want to know what you usually do when a co-worker or boss makes an ugly chart?
- You tell them the chart sucks
- You gently point out the mistakes of their chart and tell them some nicer and cooler ways to tackle it
- You stay calm and send them an e-mail later (may be with a link to PHD chart pages or something like that)
- You don’t care (and may be continue doodling)
- Any other
Vote your option using comments.Continue »
In this ironically titled “Let’s not get too excited” chart, David shows us how the twitter community is divided. Can you guess what is wrong with this chart?Continue »
The other day while doing aimless roaming on the dotcom alley, I have seen some cool optical illusions. There are so many valuable lessons optical illusions can teach us – chart makers. Don’t believe me? Look at the bubble chart illusion on the left and tell me which orange circle is bigger? What is your answer? Right or left. Well, my friend, the answer is both are of same size. Read the rest of this post to find some cool optical illusions and what they can teach us – chart makers.Continue »
The worldwide web is a wonderful place. I am constantly amazed by the simple yet very effective stuff we can learn by just reading. Today I want to share with you two very great pieces of advice: Seth Godin’s 4 Simple Principles for making effective graphs: Seth Godin is probably one of the most remarkable, [...]Continue »