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...
How-to Make a Conditional Column Chart in Excel
As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...
3 Ways to Create Vertical Lines in an Excel Line Chart
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish. We...
Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...
How-To Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...
How-to Format Trend Line Color in Excel Dynamically
Many users use Trend Lines in Excel charts and graphs. They may also be used in Company Dashboards, but to you can make your...
Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...
How-to Make an Excel Project Status Spectrum Chart
Here is the long awaited demonstration of a recent Friday Challenge.
The challenge was to recreate a Project Management Status Chart that I saw on...
Add Vertical Line Between Columns in Excel Stacked Column Chart
Add Vertical Line Between Columns in Excel Stacked Column Chart
In this tutorial, you will learn how to QUICKLY add a vertical line between columns...
Excel Stacked Area Time Chart – Friday Challenge Answer
In our recent Friday Challenge, a user asked this:
"This is a scatter with smooth line and markers graph. What I would like to have...