Visualization

Using a Panel chart (small multiples) is a great decision if you want to compare products or sales and show the data on the same scale. If you create dashboards in Excel, it is important to use space-saving methods and focus on the data. Our step-by-step tutorial shows you how to create a panel chart … Read more

Learn how to use traffic lights in Excel! Traffic lights are built for performance tracking and enable you to display project status effectively. In most cases, it’s not easy to create a native traffic light in Excel. Instead, you can use conditional formatting, shapes, named ranges, and linked pictures; if you are not in a … Read more

Bullet Graph is a great data visualization in Excel to show key performance indicators using a quality scale. We will show you how to build a bullet graph in Excel using a few steps. If you need to build a dynamic dashboard in Excel, this chart is yours! How to build a bullet graph in … Read more

Learn how to build a forecast chart in Excel! It is a custom combination chart that uses one column and two line charts. This article will show you how to create a simple forecast chart using conditionally formatted colors. What is a forecast chart? Let us see the main task: we want to show the … Read more

Dynamic charts help us to improve the quality of data visualization. In this post, we will show you the most used solutions in Excel.

Today’s guide will be all about Excel infographics. Excel is perfect for the task! We can use shapes, widgets, drawings, or texts to build a great data visualization. What are Infographics? Infographics are a collection of graphs, charts that give an easy-to-understand visual overview of data. No, we are not talking about a simple photo. … Read more

Learn how to make an org chart in Excel. Then, speed up the process using ExcelKid’s free organizational chart template add-in! The first part of the tutorial is a step-by-step guide. With its help, you will build your hierarchical org chart template in Excel using employee data. The second part of the guide will be … Read more

Learn how to change shape color based on cell value in Excel using a few steps. Get the VBA example or use conditional formatting! This tutorial will explain how to create interactive charts using conditional formatting. Believe it or not, it’s possible to change chart objects’ shape color using VBA tricks! Then, you will learn … Read more

Learn how to create a gauge Chart in Excel! A doughnut chart displays the zones, and a pie chart indicates the actual value.

How to insert sparklines in Excel? In this article, you will learn all about sparklines. Get some useful examples! Now I’ve created this post to be a follow-along lesson. You can download the Excel file that I use during the article. Sparklines are in-cell Excel charts, and we are using these graphs to show variance … Read more