Update: Check out the results at Budget vs. Actual Charts
Here is your chance to get a copy of The Visual Display of Quantitative Information by Edward Tufte. Interested ? Read on,
Reader Sumit writes in to ask,
I am working on creating a visualization for data attached in the excel file (see below). Since I was not sure as to what would be the best way in which this data can be presented, I thought I will ask for your assistance.
Would it be possible for you to play around with the data and share your ideas as to the best possible way to represent this data graphically.

Download the data in a CSV file
Even though I have few ideas on visualizing budget vs. actual performance, I thought this is a great way for You, my dear reader, to share your ideas.
So what are you waiting for? Go ahead and tell us how you will visualize this data. The best visualization maker will get eternal glory and a copy of The Visual Display of Quantitative Information by Edward Tufte.
Go!
For inspiration and ideas visit: Stacked Bar chart techniques, 14 ways to visualize last year vs. this year performance
Fine print:
Upload your visualizations (preferably images) to a public image hosting service like flickr or photobucket and share the URL here. Alternatively you can e-mail me your visualizations at chandoo.d @ gmail.com, but this takes some time.
Visualizations should be made in Excel or Google docs spreadsheets Only.
Each of you can submit as many alternatives as you can, but only one person gets the prize.
For logistical reasons, the book will be delivered to countries where Amazon operates, but if the winner is from other countries, we will work out something, so don’t be discouraged.
The contest is open until March 26, 2009. So hurry!

















7 Responses to “CP014: How to create awesome dashboards – 10 step process for you”
Very interested in topic unfortunately I get no sound when I play it.
Where can I get add ins for excel 2007
#Budala
Try using Google to search for Excel Addin
I would like to join your email newsletter.
@Andy
Goto: http://chandoo.org/wp/
The newletter registration is top Right corner
Hello Chandoo,
i am one of the great fan of your. i am one MIS executive in realstate company.And i try make dash board for CRM(Client Relation Management) Dept formance and anlysis process.Its get created not so effective according to can u suggest me .what i hve to give or take for makeing it for effective and attractive?.
regards,
Shashak verma
Hi,
I want to create an interactive dashboard in excel (Google Drive) which should have multiple data along with beautiful charts..
I handle two teams in IT Tech support so were preparing 2 different dashboards.. however need to club and want to create single report, can anyone help something like