# All articles with 'sparklines' Tag

## Employee Performance Panel Charts – Excel vs. R [video]

Published on Aug 10, 2017 in Charts and Graphs, R programming

Recently, I had to make a bunch of panel charts. After wrangling with Excel (and a tiny bit of VBA) to create them, I wondered if we are suffering needlessly by being too loyal to Excel. I switched to R and could create these panel charts in almost no time (well, first I had to learn how to pivot the data using dplyr). Today, let me share the experience.

Continue »

## Joyplot in Excel

Over on Twitter, I came across this beautiful chart, aptly titled – Joyplot. It is the kind of chart that makes you all curious and awed. So I did what any Excel nerd would do. Recreated it in Excel of course. This post takes you thru the process.

Continue »

## Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]

Published on Jul 27, 2016 in Charts and Graphs

One of the coolest features of Excel 2016 is forecasting. Today, let’s understand how it works with a sample data set.

Watch below video to understand forecasting in Excel 2016.

Continue »

## How to create dynamic sparklines for latest 30 days [video]

Published on Aug 2, 2015 in Charts and Graphs, Pivot Tables & Charts

Sparklines are fun and very insightful. They are easy to create, easy to maintain and fit into any dashboard.

But there is one tiny problem with them. Usually we have a lot of data, but we don’t to visualize all of it. We just want to visualize latest 30 days trend or last 12 months trend or QTD or something similar. What then?

In this video, learn a powerful and very simple way to create dynamic sparklines using Excel.

Continue »

## Shading above or below a line in Excel charts [tutorial]

Published on Feb 13, 2013 in Charts and Graphs

When comparing 2 sets of data, one question we always ask is,

• How is first set of numbers different from second set?

A classic example of this is, lets say you are comparing productivity figures of your company with industry averages. Merely seeing both your series as lines (or columns etc.) is not going to tell you the full story. But if we can shade our productivity line in red or green when it is under or above industry average… now that would be awesome! Something like above.

Continue »

## Excel Links – Lets meet in Chennai this Sunday edition

Published on Nov 26, 2012 in excel links

Hi readers… I am in Chennai this week, conducting in-house training at Renault Nissan on Advanced Excel. As I am busy teaching Excel & making young graduates awesome in it, I will not be able to write much on the blog. But don’t worry. We have some great articles coming up from Hui & other […]

Continue »

## Visualize Excel salaries around world with these 66 Dashboards

Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome.

See how many different ways are there to analyze Excel salary data. Look at these 66 fantastic, beautifully crafted dashboards and learn how to one up your dashboard awesomeness quotient.

Continue »

On 14th July, evening 4:51 PM (GMT), Chandoo.org received its 20,000th comment. 20,000!
The lucky commenter was Ishav Arora, who chimed, “Like super computers…Excel is a super calculator!!!!” in our recent poll.

It took us 8 years & 15 days since the very first comment to get here. And it took just 1 year 7 months & 23 days to add the last 10,000 comments (we had our 10,000th comment on 21st November, 2010).

Out of curiosity, I wanted to understand more about these 20,000 comments. So I downloaded our comment database, dumped it in Excel and start analyzing.

Continue »

## Creating Customer Service Dashboard in Excel [Part 3 of 4]

Published on Apr 18, 2012 in Charts and Graphs, Learn Excel

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.

Continue »

## Data and Calculations for our Customer Service Dashboard [Part 2 of 4]

Welcome back. In part 2 of Making a Customer Service Dashboard using Excel let us learn how the data & calculations for the dashboard are setup.

Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel

In this installment, we will examine all the variables, named ranges & various formulas that drive our dashboard. Also, you can download the full dashboard workbook and play with it to examine these formulas and learn better.

Continue »

## Designing a Customer Service Dashboard in Excel [Part 1 of 4]

Published on Feb 22, 2012 in Charts and Graphs, Learn Excel

Sawadee Krup folks. Today, we begin a new series on Chandoo.org – Making a Customer Service Dashboard using Excel. This 4 part tutorial teaches you,

Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel

Customer service is one area where a lot of data is collected regularly. Understanding all this and making business decisions is quite complex task. This is where dashboards shine.

Read on to learn how to design customer service dashboards.

Continue »

## Win Loss Chart from a Series of Win, Loss Data

Published on Jun 15, 2011 in Charts and Graphs

Last week, we learned how to create win-loss charts in Excel. In the comments, Dan said,

“Incidentally, the fastest way to do this would be using SFE, just reflect your data with 1 for a win, – 1 for a loss. There’s even an option to automatically invert negative numbers.”

Of course, we can use the beautiful Sparklines for Excel addin to do this and several other charts. But if you just have a series of Wins and Losses, like below, you can use a column chart to create win loss charts too.

Today, we will learn how to create a win loss chart from a set of win, loss data in Excel.

Continue »

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

Published on Jun 9, 2011 in Charts and Graphs

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.

Continue »

## Health-care Dashboard in Excel [Dashboard Week]

Published on Mar 22, 2011 in Charts and Graphs

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 »

## What are Excel Sparklines & How to use them? [Excel 2010]

Published on May 18, 2010 in Charts and Graphs

As part of Excel 2010, Microsoft has introduced an exciting and new charting feature called as “sparklines”. Edward Tufte coined the term sparkline and defined it as, “intense, simple, word-sized graphics”. I think adding sparklines to Excel’s pack of visualizations is a huge step in the right direction. Sparklines (often called as micro-charts) add rich visualization capability to tabular data without taking too much space. While MS’ implementation of Sparklines in Excel 2010 leaves a lot to be desired, it provides a solid platform and introduces this powerful charting idea to masses.

In this post, we explore sparklines in excel 2010 and learn how to use them. You can find several tips and ideas on implementing sparklines in your upcoming report.

Continue »