Chart
Make a Pie Chart Rating for Excel Dashboard Chart Templates
Excel Pie Chart rating system with video tutorial, sample free download template file for excel company dashboard for executives
EXPLORE THE LIBRARY
Sample File category
3D Chart
How-to Make a Company Goal Chart or IPAD Battery Chart in Excel
How to create an Excel Thermometer chart using a 3D cylinder chart or how to make an excel progress chart for IPOD IPAD Battery concept for your dashboard
Axis Formating
How-to Make a Horizontal Tornado Chart Comparison
Video Tutorial with Step-by-Step Instructions on how to make Horizontal Tornado Charts in Excel 2003 2007 and 2010 for your Executive Company Dashboard Template
Dashboard
How-to Format Trend Line Color in Excel Dynamically
Use a dynamic trend line to highlight dashboard trends in Excel templates with the use of color.
Axis Formating
How-to Show Decades and Highlight a Year in the Horizontal Axis
This is the dashboard tutorial that will show you how to only show the horizontal axis categories that you want to show and how to highlight a specific value
Chart
How-to Make a Conditional Column Chart in Excel – REDO
How-to Tutorial to learn how to make a conditional column chart with red or green columns above and below an average line.
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
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