Stacked Bar and Indicator Arrow Chart – Tutorial
Learn how to develop a Stacked Bar chart with Indicator Arrow in this Tutorial
Hourly Goals Chart with Conditional Formatting
A while back I developed a solution to a Chandoo.org Forum question, where the user wanted a 4 level doughnut chart where each doughnut was made up of 12 segments and each segment was to be colored based on a value within a range. If the values changed he wanted the chart to update, Conditional Formating like:
This post looks at how this was achieved.
Visualizing Financial Metrics – 30 Alternatives
Around 2 months back, I asked you to visualize multiple variable data for 4 companies using Excel. 30 of you responded to the challenge with several interesting and awesome charts, dashboards and reports to visualize the financial metric data. Today, let’s take a look at the contest entries and learn from them.
First a quick note:
I am really sorry for the delay in compiling the results for this contest. Originally I planned to announce them during last week of July. But my move to New Zealand disrupted the workflow. I know the contestants have poured in a lot of time & effort in creating these fabulous workbook and it is unfair on my part. I am sorry and I will manage future contests better.
Correlation vs. Causation [Charting Chatter]
Here is a trap that is easy to fall in to. Confusing correlation as causation. As analysts, it is our job to see the data as it is rather than imply causation that doesn’t exist.
Let’s sample a chart, recently featured in Economist’s graphic detail under the title Measuring well-being.
Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]
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.
How to get Maps in to Excel charts & dashboards [Master Class]
This is third episode of our Monthly Master Class.
In this one, you will learn how to get maps in to your Excel workbooks. Understand 5 key techniques for making maps based visualizations in Excel – from regular charts to cell grids to VBA to Power Maps, everything is covered in this intense Master Class.
How to visualize multiple variables over several years? [Contest]
Our newest contest is inspired from a question asked by Kaushik, one of our forum members, interesting problem.
Need to quickly visualize 3 variables ( Company, years, Financials) in a single […] chart.
Create a chart to understand multiple variable data and you could win $100 Amazon gift card. Do send your charts before 4th of July to qualify for the prizes.