How to pick a chart type – Charting 101
Bar chart or Line? Scatter plot or box plot? These are the questions we ask ourselves when we set out to make a chart. Because, “Selecting right chart for our data” is very important to tell our story.
In this article, we will learn how to “select the right chart” based on our data and situation.
How to Visualize Survey Results using Incell Panel Charts [case study]
A panel chart (often called as trellis display or small-multiples) shows data for multiple variables in an easy to digest format. It lets users compare in any way and draw conclusions with ease.
Today, I want to discuss how the principles of panel chart can be applied to visualize a complex set of survey results. For this we will use the recent survey conducted by Gartner on how various customers use BI (Business Intelligence) tools.
Introducing Flag Project – A fun way to Learn Excel Charting
I have a new community project for all the members of PHD. It is a simple yet intuitive challenge. Make your own country’s flag using Excel Charts. To start the project, I have made the Indian flag using a bar and pie chart. Go ahead and see the rest of this post to findout how this chart is made and then participate in the “flag project” by making your own country’s flag. All the best.
Annual Goals Tracker Sheet [awesome ways to use excel]
Marko, who is a long time PHD reader and an excel ninja sent this via email, I work at an insurance company in Slovenia. At the beginning of each year we have a conversation with our superiors to review our work in the past year and to set new goals (main activities) that we’re gonna […]
Use Paste Special to Speed up Chart Formatting [Quick Tip]
Excel Paste Special is one of my favorite features. So I was naturally thrilled when I discovered that you can use paste special to paste formatting from one chart to another. When we have multiple charts, ensuring consistent color schemes, fonts etc. is very important. Often we individually format the charts because they have different […]
What is the most useless feature in Excel? [poll]
What do you think is the most useless feature in MS Excel? I know there are a ton of cool, extremely useful features in excel. But it also comes with a few really un-necessary features. For me, the most useless feature seems to be a 3D surface chart. I have tried to figure why this […]
Flu Trends in a City chart from Google is Awesome!
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…