How-to Make Excel STOP Selecting Range/Extending Range

10
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on a new cell or change cells with the arrow keys? ...
Line Feed in Excel Cell

Excel Line Break/Hard Return within a Cell

4
Most people don't know that you can put a Hard Return (Line Break) within a cell because when they hit enter Excel takes them to a new cell.  It is pretty simple to learn how to...
Sample Displays of Excel Chart Dashboard Designs using Axis Groupings

Dashboard Design Examples – Excel Chart X-Axis Grouping

0
When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data. Which do you prefer? Which chart would you want your Executives to view in...
How-to Hide Pie Slices when Value Equals Zero

How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section

5
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste of one that I wish I had learned a long...

How-to Make a Dynamic Chart Using Offset Formula

1
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables.  This is a very easy method to make a Dynamic Excel Graph, however, it may...
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 Template and Chart file to track my weight and plot...
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 Formula.  Understanding the Offset Formula is critical to understanding how...

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 Chart that they were creating.  I thought I would help...

Group Column Chart with Lines for Excel Dashboard Presentations

1
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a Line and Label the Line. Here was the sample picture presented...

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 a Horizontal Line and the other metric was a Vertical...