Chart
How-to Make a Conditional Column Chart in Excel
A quick way to make a conditional column chart showing red and green bars in an excel spreadsheet
EXPLORE THE LIBRARY
Category
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
Chart
How-to Format Chart Axis for Thousands or Millions
Excel Dashboard Format Design for Millions or Thousands Chart Axis number categories
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
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
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