6 Best charts to show % progress against goal
Back when I was working as a project lead, everyday my project manager would ask me the same question.
“Chandoo, whats the progress?”
He was so punctual about it, even on days when our coffee machine wasn’t working.
As you can see, tracking progress is an obsession we all have. At this very moment, if you pay close attention, you can hear mouse clicks of thousands of analysts and managers all over the world making project progress charts.
So today, lets talk about best charts to show % progress against a goal.
Creating In-cell charts with markers for average (or target) values
Today, lets talk about an interesting extension to the idea of in-cell charts. Adding average or target markers to the chart.
Adding a marker (like average or target or last year value) can enhance your charts greatly and provide more context. Lets understand how to add marker symbols to in-cell charts.
People & Websites that Helped me in 2011 [Thank you message]
2011 has been the most awesome year since we started Chandoo.org.
Without doubt, the credit goes to our community – that is you.
I feel very fortunate to have you in our community. You inspire me to learn & share. I know I said this several times, but everytime, I feel like I have not done enough. Thank you so very much.
Apart from our little community, I feel thankful to many others, who have helped me through out 2011 to make you awesome in Excel. In this post, I am highlighting them & expressing my gratitude.
Incell Sales Funnel Charts
Sales Funnel or Sales Process refers to a systematic approach to selling a product or service. [more on sales process] Whether you run a small business or part of a large corporation, chances are, you heard about Sale Funnel. Understanding & analyzing your sales performance from a Funnel point of view is a great way […]
How to create a Win-Loss Chart in Excel? [Tutorial & Template]
Win Loss Charts are an interesting way to show a range of outcomes. Lets say, you have data like this:
win, win, win, loss, loss, win, win, loss, loss, win
The Win Loss chart would look like this:
Today, we will learn, how to create Win Loss Charts in Excel.
We will learn how to create Win Loss charts using Conditional Formatting and using In-cell Charts.
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.
Excel Links – My First International Excel Workshop Edition
Stage is almost set for my first international Excel workshop. That is right. I am doing a physical excel workshop on Intermediate & Advanced Excel at Maldives between January 23 and 27, 2011. I feel quite excited to do this.
While I derive immense pleasure and learn lots of new things by running Excel School, there is one nagging problem. It is an online program, so the scope of physical interaction with students is limited.
Doing a physical class is a great way to meet new people, gather material for new content, get ideas, learn new things and get challenged. And that is why I am looking forward to do my workshop in Maldives next week.
If you would like to join this workshop: Please call Mr. Guru Raj, Training Manager at IIPD, Malè. His number is +960 7625338. (Workshop agenda)
Because I will be busy with the workshop next week, I will not be able to post much on the blog. I have requested Hui, our guest author to keep you all engaged. So expect some delicious stuff from him while I am away.