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
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
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
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
Learn how to make Excel Dashboard Template Charts using Offset Formulas to define Dynamic ranges.
Video Tutorial on how-to make an Excel Line Chart Template Chart for Company and Executive Dashboards using Tables
Excel Dashboard Spreadsheet Charts for Tiger Woods PGA and Major victories Redo from NY Times graph
Tutorial/How-to/Step-by-Step on creating a P/E Ratio Line Chart for Excel Dashboard Template for Company and Industry markers
How to Make a P/E chart in Excel How to Make a P/E chart in Excel Here is a fun and easy Dynamic Excel Chart that you can use in your Excel Dashboard Template. This Excel Chart has many fina
Advice and Ways to build Concatenate formulas in your Excel Dashboard Templates.
Referring to Cells and Ranges of Cells in Formulas for your Excel Dashboard Templates
How to optimize your cell references in Excel Dashboard Template Formulas