All articles with 'charting' Tag
Learn Advanced Excel – 3 Month Roadmap with Resources

Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.
Continue »6 Must Know Line Chart variations for Data Analysis

Line charts in Excel are essential for trend analysis, spotting distribution and outliers. Use these 6 variations to get more out your line chart.
- Indexed Line Chart
- Sparklines
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations
Project Plan – Gantt Chart with drill-down capability [Templates]
![Project Plan – Gantt Chart with drill-down capability [Templates]](https://chandoo.org/wp/wp-content/uploads/2020/07/interactive-project-gantt-chart-demo.gif)
Create a gantt chart with ability to filter by levels. This drill-down gantt chart in Excel is useful for seeing activities by module or team. Read on for full instructions + downloadable template.
Continue »How to make an Interactive Chart Slider Thingy

Ok, I will be honest. I have no idea what to call it. May be Chart Cover Flow? But Interactive Chart Slider Thingy sounds so better. So let’s go with it.
Learn how to create this magical contraption in Excel.
Continue »How to show positive / negative colors in area charts? [Quick tip]
![How to show positive / negative colors in area charts? [Quick tip]](https://chandoo.org/wp/wp-content/uploads/2020/05/area-chart-with-up-down-colors-pt.png)
Ever wanted to make an area chart with up down colors, something like this? Then this tip is for you.
Continue »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 »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.
Continue »
Slope line is very useful for spotting which values have changed from two sets. You can add a slope line to XY chart (scatter plot) using simple techniques. In this post, learn how to add them.
Continue »Impress with Tornado Charts in Excel

It’s tornado season. Don’t freak out, I am talking about Excel tornado charts. Use them to visualize age and gender-wise KPIs. Here is a quick demo of interactive tornado chart made in Excel. Watch it and read on to learn how to make your own tornado in a spreadsheet.
Continue »
I have been playing Zelda: Breath of the wild a lot these days and I LOVE the game. Considered one of the BEST video games all time, BOTW is beautifully designed and offers a lot of entertainment. Don’t freak out yet, Chandoo.org hasn’t suddenly branched into a video gaming blog. Instead, I am here to talk about Stamina Wheel Chart.
Continue »How-to highlight maximum value in Excel charts? [Quick tip]
![How-to highlight maximum value in Excel charts? [Quick tip]](https://chandoo.org/wp/wp-content/uploads/2019/08/highlight-maximum-value-in-excel-charts-m.png)
Ever wanted to highlight maximum value in charts? Then this tip is for you.
Continue »Tour de France – Distance & Pace over time – Radial Charts

This is an Excel replica of excellent Tableau visual on Tour de France winner data made by Marc Reid.
Last week I saw a stunning visualization on Tour de France using radial charts. I wanted to replicate it in Excel. So here we go.
Continue »Make info-graphics with shape fill technique [Charting Tip]
![Make info-graphics with shape fill technique [Charting Tip]](https://chandoo.org/wp/wp-content/uploads/2019/07/make-info-graphics-in-excel.png)
This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:
Continue »5 simple rules for making awesome column charts

For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.
Tip: Same rules apply for bar charts too.
Continue »Source vs. Use of Funds – 14 charting alternatives

Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you tell the story of source vs. uses of funds? In this post, let’s review 14 charting options. Source vs. Use of funds – Sample Data for this problem Let’s say […]
Continue »