Visualization

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

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