How To Create Tornado Chart (Butterfly Chart)

There’s many ways to create Tornado Chart, I’ll share with you another example, see the final chart: This chart is really looks like a butterfly. OK, let’s jump straight into creating a Butterfly Chart. Download and Install The XY Chart Labeler The XY Chart Labeler is a useful Add-ins to…

How To Use Clustered Bar to Create Tornado Chart

Yesterday, I post how to use Conditional Formatting to create Tornado Chart, today, I’ll show you how to use Clustered Bar to create Tornado Chart. Here is our final Tornado Chart: OK, let’s jump straight into creating a Tornado Chart. Getting the data In this tutorial, we will compare the…

How To Use Conditional Formatting to Create Tornado Chart

Tornado Chart is a special type of Bar Chart, also called Tornado Diagram. Tornado Chart is useful for deterministic sensitivity analysis. We usually building Tornado Chart with Bar Chart, but in this tutorial, I’ll show you how to use Conditional Formatting to create Tornado Chart in Excel 2010. Prepare your…

Nightingale Rose Diagram Excel Template

Nightingale Rose Diagram is the most famous statistical diagram. It’s a form of the Pie Chart now known as the Polar Area Diagram. We often see it in the Business Magazines, Newspapers and Journal of Finance. In this tutorials, I’ll show you two styles of Nightingale Rose Diagram Template use…

How To Create Sparklines Use Excel Functions

Sparklines is new in Microsoft Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. This tutorial helps you how to create Sparklines use Excel Functions. Note: this tutorial works well in excel 2003, 2007, 2010, 2013. What is Sparklines? A sparkline is a very…