Select Page

## How to Create Charts with Formula in Excel

Excel keeps growing its visualization tools with each version. And the charts are the flagship of those. Although they present lots of customization options, they may become overwhelming when you just need to create a simple bar or column chart. In this guide, we’re...

## How to Perform Trend Analysis with Charts in Excel

Excel charts can do more than visualizing the data, like calculating and showing trends and moving averages. In this guide, we’re going to show you How to perform trend analysis with charts in Excel. Download Workbook Performing Trend Analysis with Charts Creating a...

## How to create ridgeline plot (joy plot) in Excel

A ridgeline plot, also known as a joy plot, is a chart type visualizing the data as overlapping density curves. Joy plots got its name from the album cover Unknown Pleasures by Joy Division in 1979. They are good-looking visualizations for comparing the distributions...

## How to Create Tornado Charts in Excel

A Tornado Chart is a fancy form of a bar chart. They shine when the goal is to compare two variables. Although Excel doesn't support tornado charts natively, they are a few simple steps far away from you. In this guide, we’re going to show you How to Create Tornado...

## How to create waffle charts in Excel

A waffle chart is basically a square display that shows progress towards a target or a completion percentage. They can be a fancy alternative to pie charts. In this guide, we’re going to show you How to create waffle charts in Excel. Download Workbook Creating a...

## How to visualize percentage progress in Excel

Nothing beats visuals when you need a simple way to track progress. Visual indicators can tell you which project is leading immediately without delving into numbers. In this guide, we’re going to show you How to visualize percentage progress in Excel. Download...

## How to create a progress chart in Excel

In this guide, we’re going to show you how to create a progress chart in Excel. Download Workbook Steps to create a progress chart 1.      Calculate remaining process Start by calculating the remaining process. If you are using a percentage value, the formula will...

## How to format axis labels individually in Excel

In this guide, we’re going to show you how to format axis labels individually in Excel. Download Workbook As you have already known that there is no way to select an individual item in a chart axis. This is because Excel populates axis points on the fly based on data...

## How to set different colors to positive and negative numbers in a column chart in Excel

Color differences are probably the first thing that human eye can catch. Because a visualization should be easy to understand, different colors may be your best option to express opposite data like positive and negative values. In this guide, we’re going to show you...