Create a line chart with bands [tutorial]
Here is an interesting scenario.
Imagine you are responsible for customer satisfaction at ACME Inc. Every month you track customer satisfaction rate for the 3 products you sell which are conveniently named Product A, B & C.
You also have bands for the satisfaction rating.
- Rating of 85% or below is Average
- Rating between 85% & 95% is OK
- Rating above 95% is good
At the end of the year, you want to visualize the ratings for last 12 months for 3 products along with bands.
Something like above.
Unfortunately, there is no “Insert Banded line chart” button in Excel. So what to do?
That is what we will learn today. Ready?
Change Data Labels in Charts to Whatever you want [Quick Tip]
We all know that Chart Data Labels help us highlight important data points. When you “add data labels” to a chart series, excel can show either “category” , “series” or “data point values” as data labels.
But what if you want to have a data label that is altogether different, like this:
Of course you can point data labels to any cell. In this quick tip, we will learn how to do this, read on…
A Brief History of Microsoft Excel – Timeline Visualization
Timeline charts are great for providing quick snapshots of historical events. And hardly a day goes by without some one making a cool visualization of a time line of this or that. Time lines are easy to read, present information in a logical manner and mostly fun.
So yesterday, I set out to mimic the iconic gadgets of all time in excel, just for fun. Then it strike me, why not make a visual time line of Microsoft Excel ? So I did that instead.
Make a Quick Thermometer Chart to Compare Targets and Actuals
Comparing values is one of the reasons why we make charts. So today I am going to teach you a handy little trick to make a thermometer like chart to compare targets with actuals. This type of chart is very useful when you have a bunch of sales targets and you want to measure how the performance has been.
Dashboard Best Practice – Google Analytics Intelligence Report
Yesterday while checking my website analytics reports on Google analytics site, I have noticed a new beta feature called “Intelligence”. Out of curiosity I clicked on it. It took me to a an intelligence alert dashboard. Ok, lets just back up for a minute and understand what “intelligence dashboard” is before moving on. In the […]
Making Interaction Plots using Excel
Yesterday I read about interaction plots on junk charts where he points out the merits of an interaction plot. Interaction plots show interaction effects between 2 factors. For eg. you can show how your product sales have changed between year 1 and year 2 using an interaction plot like the one shown aside.
Make a Bubble Chart in Excel [15 second tutorial]
A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.