What are Excel Sparklines & How to use them? 5 Secret Tips
Of all the charting features in Excel, Sparklines are my absolute favorite. These bite-sized graphs can fit in a cell and show powerful insights. Edward Tufte coined the term sparkline and defined it as,
intense, simple, word-sized graphics
Sparklines (often called as micro-charts) add rich visualization capability to tabular data without taking too much space. This page provides a complete tutorial on Excel sparklines.
Creating Customer Service Dashboard in Excel [Part 3 of 4]
Welcome back. In third installment of our Customer Service Dashboard series, we will learn how to construct the charts in our dashboard. We will understand the sparklines, traffic lights & dynamic chart setup. To help you learn better, I have recorded a short video too. Go ahead and enjoy.
How to add your own Macros to Excel Ribbon [quick tip]
Do you know that in Excel 2010 you can create your own Ribbon tabs and add anything to them, including your own macros? Today, we are going to take a look at this useful feature and learn how to add your own macros as buttons to Excel Ribbon. Steps to Add your own macros to […]
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.
Switch Scenarios Dynamically using Slicers
Slicers are my new favorite feature in Excel. Introduced in Excel 2010, Slicers are like visual filters.
Now, we can use slicers creatively to make an interactive scenario manager in Excel, as you can see below. We will learn how to create this in Excel in today’s post.
Make Dynamic Dashboards using Pivot Tables & Slicers [Video & Download]
Do you know that Excel 2010 makes creation of dynamic dashboards very simple?
Yes, that is right. Using slicers feature, you can create dynamic excel dashboards from your data in very little time. Today we are going to learn a technique that will help you create a dashboard like below.
Read rest of this post to find out how to construct a dynamic dashboard in Excel & download the example workbook.
Updates on Website, Office 2010 Contest
We have updates!!! Chandoo.org on Cloud: Everybody and their grandmother is going cloud these days. Although I am quite nebulous about this cloud thing, over the weekend, I mustered some courage and messed with Amazon Cloud Front. I am happy to tell you that Chandoo.org should feel faster and more responsive as I moved some […]