All articles with 'charting' Tag
Make an Impressive Interactive Map Chart in Excel
Today, let’s learn how to make an impressive map chart with Excel. Something like this.Continue »
Top AI features in Excel – a round up
Don’t feel like doing the Excel work yourself? You can ask the AI features of Excel ? to automatically do stuff for you. Save time and look like a hero at work ????????.Continue »
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
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations
Project Plan – Gantt Chart with drill-down capability [Templates]
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]
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 »
Add slope line to XY charts
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 »
Zelda Stamina Wheel Chart
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]
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]
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 »