90% of you can see up to cell M26 & other findings [visualization]
Two weeks back I ran a poll asking you to tell me what is the last visible cell in your excel window. It was a casual poll. So I didn’t expect a lot of responses. But, boy I was wrong! 295 of you have responded at last count. This is so much more than what I expected.
As I said, the purpose of this poll is to make a visualization out of the poll responses. In this post you can see the chart(s) I made from this data & learn more.
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.
Lets Pimp a Gauge Chart [Chart Porn Friday]
Egil, one of our alert readers from Norway sent this to me in e-mail, which I swear, I am not making up – A Fancy Gauge Chart. See the e-mail and chart yourself. I’m having a lot of fun with your gauge template 🙂 To make it more industrial-like, I’ve added: 1. Brushed metal background […]
Recipe for a Donut Bar Chart
We all know that bar charts can be used to display values spread across various categories or times and pie charts / donut charts can be used to display percentage breakup of various quantities in a sum total. How about mashing up both to create a Donut Bar chart?
In this tutorial, you can learn how to make a donut bar chart and linking it to a form control to display Product-wise sales breakups spread across several years.
Pareto Charts – How to do pareto analysis using Excel?
A Pareto chart or pareto graph displays the importance of various factors in decreasing order in columns along with cumulative importance in a line. Pareto charts are often used in quality control to display most common reasons for failure, customer complaints or product defects. The pareto chart is a great way to do the pareto analysis. Today, we will learn how to use excel to make a pareto chart.
Using Combo Charts to Group Related Time Events [Charting Goodness]
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.
Waterfall Charts using Excel
Learn how to create waterfall charts in Excel in this tutorial. Our guest author, Aaron, explains how to create cool looking waterfall charts with connectors. Waterfall charts are great, especially for visually showing the contribution of parts to a whole.