Banding Horizontal
Dashboards are Everywhere!
Look for dashboard designs in every day life to make your excel dashboards better and more useful.
EXPLORE THE LIBRARY
Tag
Axis Formating
Date and Time Series Issues in Excel Charts
If your chart in Excel is showing every date and you only want to show the dates in your data series on the Horizontal X Axis
Cell References
How-to Copy Charts and Change References to New Worksheet
How to copy an Excel Chart and Range and paste into a new worksheet, but change the chart series to reference a the new range.
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 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
Dashboard
Tiger Woods PGA Tour and Major Championship Chart
Excel Dashboard Spreadsheet Charts for Tiger Woods PGA and Major victories Redo from NY Times graph
Chart
Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart
Tutorial/How-to/Step-by-Step on creating a P/E Ratio Line Chart for Excel Dashboard Template for Company and Industry markers