Change Shape Color based on a cell value

Change Shape Color based on a cell value

Learn how to change shape color based on cell value in Excel using a few steps. In this tutorial, we will explain how to create interactive charts using conditional formatting. Believe it or not, it’s possible to change shape color on chart objects using some VBA tricks! You will learn how to extend the formatting … Read more

Gauge Chart

gauge chart

The popularity of the gauge chart is indisputable. It’s a combination chart: a doughnut that displays the zones, and a pie chart indicates the actual value. Not only is it used by Excel PowerBI but leading BI providers too. When you look at the above visualizations, it is clear why it is so widely used. … Read more

How to create a drop-down list in Excel

drop-down list in excel

Using the drop-down list, we can choose elements from a predefined list. It is beneficial when, for example, we would like to show the efficiency of different departments within one company. Moreover, it is worth using because when choosing its elements, the dashboard automatically refreshes and likewise the connecting charts. Forget all user-generated errors! Drop-down … Read more

Sparklines in Excel

excel sparklines

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

How to install an Excel Add-in

how to install an excel add-in properly

Learn how to install an Excel add-in and how to fix the disappearing add-in ribbon using a few simple steps. Don’t forget to enable the Developer tab!