Chart
How-to Format Chart Axis for Thousands or Millions
Excel Dashboard Format Design for Millions or Thousands Chart Axis number categories
EXPLORE THE LIBRARY
How-To
Cell References
How-to Make Excel STOP Selecting Range/Extending Range
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
Formatting
Excel Line Break/Hard Return within a Cell
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 do this and
Chart
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Hiding Excel Pie Chart Slice when equal to 0 also how to hide stacked bar chart section using NA()
Chart
How-to Make a Dynamic Chart Using Offset Formula
Offset function to make a dynamic chart for Excel dashboard templates
Bar Chart
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 Chart that they were creating. I thought I would help
Chart
Group Column Chart with Lines for Excel Dashboard Presentations
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
Chart
How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Step-by-Step Tutorial and Video on how to make an Excel Chart that displays a Vertical and Horizontal Line intersect using XY Scatter Lines
Cell References
This is the Bomb: or How I came to love the Offset function
Learn how to make Excel Dashboard Template Charts using Offset Formulas to define Dynamic ranges.
Chart
How-to Make Dynamic Excel Dashboard Charts Using Tables
Video Tutorial on how-to make an Excel Line Chart Template Chart for Company and Executive Dashboards using Tables