All articles with 'conditional formatting icon sets' Tag
In this amazing guest post, the winner of our 2016 dashboard contest – Chandeep – Explains how he constructed the jaw dropping beauty (shown above) using Excel, creativity, love and sweat. Grab a full cup of coffee (or whatever liquid fancies you) and read on. Take lots of notes and play with the ideas in Excel while reading to maximize your learning.
Thanks Chandeep.Continue »
One of our readers emailed this question recently,
I like the conditional formatting icons. I am trying to present some business data where going down is good. How do I get a green colored down arrow icon?
Essentially, Ms. CanIGetItInGreen wants this:
Unfortunately, Excel’s conditional formatting icons are not customizable. So we can’t get the green down arrows without some sneak. And sneak we shall.Continue »
Whenever we talk about product ratings & customer satisfaction, 5 star ratings come to our mind. Today, let’s learn how to create a simple & elegant 5 star in-cell chart in Excel. Something like above.
Read on to learn how to create the above chart.Continue »
Conditional formatting is one of the most powerful & awesome features of Excel. It is very easy to setup. Naturally, people use it extensively. But the default conditional formatting rules can clutter your reports. Here is one tip that can declutter your reports.
Just show the formatting, not values.
See the above report.Continue »
Here is a familiar problem: You create a workbook to track some data. You ask your staff to fill up the data. Almost all the input data is fine, except the date column. Every one types dates in their own format. Here is a fun, simple & powerful way to warn your users when they […]Continue »
It is Easter time again. Every year, we at Chandoo.org celebrate Easter by hunting for eggs (not in the wild, just in the Excel workbooks). This year too I have hidden 30 Excel tips in a workbook. You have to solve 3 puzzles to find them. So what are you waiting for. Go ahead and hunt for them eggs.
I am sure you will enjoy them 🙂Continue »
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 »
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 discussed user needs & design. Part 2 will show you Excel implementation.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.Continue »
Pivot tables are great help when analyzing lots of data. One of the common questions managers & analysts ask (when looking at monthly sales data for example) is,
How is the monthly performance of our teams (or regions, products etc.)?
A pivot report can answer this question in a snap. Today lets learn how to do that.Continue »
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 »
Last week, we learned how to visualize Suicides vs. Murders data using Interactive charts in Excel. William, one of our readers, took this technique and applied it to Stocks. He emailed me because he has some formula issues with the stock data. Once I solved the problem, I asked him, “Can I share this with […]Continue »
Over at PTS Blog, my dear friend & charting guru, Jon Peltier has an interesting post on using dot plots to visualize Murders & Suicides data by US States.
Not that murders & suicides fascinate me, but I wanted to play with this data myself and see how we can visualize it. So I emailed Jon and asked him to share the raw data. Being a lovely chap Jon is, he immediately sent me the data. So here we are, playing with gory data on a Friday.
Suicides & Murders by US States – An Interactive Excel Chart
You can see a demo of the chart I came up with above. Read on to learn how this chart is constructed.Continue »
Any Tom, Dick and Sally can make things complex. It takes guts and clarity to simplify things. That is why I was pleasantly surprised to see this dashboard prepared by Michigan State. You can see it in the detailed article.
Linda, one of My Excel School students shared this dashboard link with me and asked if I can show how to construct something like this. Here is my version of the dashboard.
Read this post to learn how to construct a similar dashboard on your own. Also, you can download the excel workbook and play with it.Continue »
In 2008, I received an email from Robert Mundigl, which was the start of a life-long friendship. Robert asked me if he can teach us how to make KPI dashboards using Excel. I gladly said yes because I am always looking for new ways to use Excel.
The original KPI dashboards using Excel article was so popular. They still help around 12,000 people around the globe every month. Many of our regular readers and members have once started their journey on Chandoo.org from these articles.
In this article, we will revisit the dashboard and give it a fresh new spin using Excel 2007.Continue »
As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto. He put together an excellent dashboard to visualize hospital performance and understand what is going on. Read this post to understand how this dashboard is made, watch a tutorial video & download example workbook.
Thank you Alberto for sharing the file & helping us learn.Continue »