How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
Create a Dynamic Excel Pie Chart
How-to Create a Dynamic Excel Pie Chart Using the Offset Function
Recently, I viewed a forum post where a user wanted to create a dynamic...
Free Dashboard Template Download – BMI Weight Tracker
In this ever expanding universe, so is my belt. I need to drop more than a few pounds.
Now I can use an Excel Dashboard...
How-to Add Custom Labels that Dynamically Change in Excel Charts
Have you ever wanted to have a different data point label in your Excel Chart than what is offered by the Standard Excel Dialog...
How-to Make an Excel Chart Title Change Dynamically
Have you ever wanted to change your chart title dynamically?
Perhaps you wanted to link it to a cell value?
Did you know that it...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
How-to Create a Dynamic Excel Chart that Only Displays Non-Blank Values
Below is a video that may help you as well.
How-to make a Dynamic Excel chart that doesn't show blank values so you don't have to...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
Show or Hide Selected Chart Data Points in Excel with VBA
Okay, for the last challenge, Peter went above and beyond and also submitted a VBA solution to this problem. Great job Peter!
Here is how...
How-to Make Dynamic Excel Dashboard Charts Using Tables
For almost every Excel Dashboard you will want to make a Chart template Dynamic. Meaning that as you add new data, the chart updates...