All articles with 'rept' Tag

Creating In-cell charts with markers for average (or target) values

Published on Dec 3, 2014 in Charts and Graphs
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.

Continue »

6 Best charts to show % progress against goal

Published on Mar 10, 2014 in Charts and Graphs, Learn Excel
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.

Continue »

People & Websites that Helped me in 2011 [Thank you message]

Published on Dec 28, 2011 in blogging

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.

Continue »

Incell Sales Funnel Charts

Published on Sep 29, 2011 in Charts and Graphs
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 […]

Continue »

How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Published on Jun 9, 2011 in Charts and Graphs
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:

Win Loss Charts in Excel - Template & Tutorial

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.

Continue »

Show Details On-demand in Excel [Tutorial + Training Program]

Published on Apr 7, 2011 in Charts and Graphs, products, VBA Macros
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.

Continue »

Excel Links – My First International Excel Workshop Edition

Published on Jan 17, 2011 in excel links
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.

Continue »

Excel Animation without Macros!

Published on Nov 30, 2010 in Charts and Graphs, Learn Excel
Excel Animation without Macros!

Today we will learn an interesting animation technique that ONLY uses, … wait for it …, Excel Formulas. That is right, we will use simple formulas to animate values in Excel.

Intrigued? Confused? Interested?

First see a short demo of excel animation achieved using this technique.

Now read the rest of this post to learn more about this technique and download sample workbook.

Continue »

Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]

Published on Apr 9, 2010 in Charts and Graphs
Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]

In a follow up to last week’s how to visualize survey data in excel, we will explore how you can create an incell dot plot panel chart. Please follow the links in the article to get more commentary and insights from established persona in the visualization world (including Stephen Few, Naomi, Jon etc.)

Continue »

How to Visualize Survey Results using Incell Panel Charts [case study]

Published on Apr 1, 2010 in Charts and Graphs, Featured, Learn Excel
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.

Continue »

Use “Playbill” font to make your incell charts realistic [quick-tips]

Published on Jan 21, 2010 in Charts and Graphs
Use “Playbill” font to make your incell charts realistic [quick-tips]

Most of you already know that using the REPT formula along with pipe (“|”) symbol, we can make simple in-cell charts in excel. For eg. =REPT(“|”,10) looks like a bar chart of width 10. Despite the simplicity, most people don’t use in-cell charts because these charts don’t look anything like their counterparts. But you can […]

Continue »

50 Best Cities for Finding a Job [Incell Dashboard using Excel]

Published on Aug 20, 2009 in Charts and Graphs, Learn Excel
50 Best Cities for Finding a Job [Incell Dashboard using Excel]

We all know that incell charts are a very cool way to explore and visualize data. Personally I like them so much that I have written several tutorials on it here. Today we will see how a Job dashboard on “50 best cities for finding a job” originally prepared by Indeed job search engine can be recreated in Excel using In-cell charts. The final outcome is something like this.

Continue »

Incell Dot Plots in Microsoft Excel

Published on Jun 10, 2009 in Charts and Graphs, Learn Excel
Incell Dot Plots in Microsoft Excel

Dot plots are a very popular and effective charts. According to wikipedia “Dot plots are one of the simplest plots available, and are suitable for small to moderate sized data sets. They are useful for highlighting clusters and gaps, as well as outliers.”

Today we will learn about creating in-cell dot plots using excel. We will see how we can create a dot plot using 3 data series of some fictitious data.

Continue »

Incell Bar charts – Revisited

Published on Jul 15, 2008 in Charts and Graphs, hacks, ideas, Learn Excel, technology
Incell Bar charts – Revisited

I can never get tired of in-cell charts, whenever I get sometime, I try to experiment something on them. Here is an idea to design true incell column charts without using any add-ins or installing fonts. These charts can be fun to have on your project report or annual news letter or memos, they take […]

Continue »