Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings
Recently I saw this in the MrExcel Forums. The title “Weird Charts with 3 Axis” intrigued me.
I determined that they were looking to put...
How-to Build a Plan vs Actual Excel Dashboard
Hi All, I wanted to share with you a great post from a fellow Excel creator and teacher. Mynda Treacy has just released a...
How-to Recreate a NYT InfoGraphic Mustache Grouping Chart in Excel
I love trying to create an Excel chart that was originally drawn with an Infographic software package. Back in 2011 I saw a New York...
How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard
Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very...
Olympic Medal Count Dashboard
So the summer Olympics start this week. So I thought it would be a good time to visit how one might create an Olympic...
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data.
Read it over, but really, the last line of the...
How-to Create Dynamic Excel Dashboards Using Picklists
This is a great technique that you can use to create dynamic charts that will change when your users change the values from the...
How-to Highlight or Color Rings in an Excel Radar Chart
Recently a user in an Excel Forum wanted to know if there was any way to highlight or color the outside ring of an...









