Quantcast

How-to Show Decades and Highlight a Year in the Horizontal Axis

4
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

2
· 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

3
As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...
Download a Free Target BMI Weight Tracker Spreadsheet

Free Dashboard Template Download – BMI Weight Tracker

13
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...
Count Function

Find the Last Row or Last Column for Dynamic Excel Dashboards

0
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

6
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

4
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
Sample File of Excel Template Dashboard Tutorial Offset Function

This is the Bomb: or How I came to love the Offset function

7
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

1
For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link