Axis Formating
Using the Camera Tool to Create a Vertical Line Chart in Excel
Using the Camera Tool to Make a Dynamic Dashboard Vertical Line Chart in Excel
EXPLORE THE LIBRARY
Month
Chart
How-to Format Chart Axis for Thousands or Millions
Excel Dashboard Format Design for Millions or Thousands Chart Axis number categories
Print Columns
How do I Print Repeating Rows or Columns for my Excel Report?
How to Print Excel Spreadsheet Print Titles for a Company Dashboard Template so that rows repeat on every page and columns repeat on every page
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
Bar Chart
Dashboard Design Examples – Excel Chart X-Axis Grouping
Sample chart design displaying Axis groupings for Excel Dashboards
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
Banding Horizontal
Free Dashboard Template Download – BMI Weight Tracker
Free download file and instructional video on using the sample excel BMI Target Weight Loss Dynamic Dashboard Chart
Cell References
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 Formula. Understanding the Offset Formula is critical to understanding h