by Ilker | Jun 23, 2022 | Excel Tips & Tricks
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...
by Ilker | Apr 7, 2022 | Excel Tips & Tricks
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...
by Ilker | Apr 1, 2022 | Excel Tips & Tricks
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...
by Ilker | Mar 31, 2022 | Excel Tips & Tricks
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...
by Ilker | Feb 23, 2022 | Excel Tips & Tricks
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...
by Ilker | Feb 22, 2022 | Excel Tips & Tricks
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...
by Ilker | Nov 29, 2021 | Excel Tips & Tricks
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...
by Ilker | Nov 4, 2021 | Excel Tips & Tricks
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...
by Ilker | Oct 13, 2021 | Excel Tips & Tricks
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...