How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
How-to Make a Conditional Column Chart in Excel – REDO
·
In a previous post, I showed you how to make a Conditional Column Chart for your Executive Dashboard Templates, but I had 3...
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...
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...
Find the Last Row or Last Column for Dynamic Excel Dashboards
In a previous post “This is the Bomb: or How I came to love the Offset function” I showed you all about the Offset...
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 Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
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...
