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...
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 Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart
In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will...
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...
How-To Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...
Tiger Woods PGA Tour and Major Championship Chart
I am a fan of the PGA and Tiger Woods. So I was really excited when I saw this post from Paresh Shah of...
Dashboard Design Examples – Excel Chart X-Axis Grouping
When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data.
Which do you...
Friday Challenge – How Would You Chart It?
Today the ExcelDashboardTemplate.com Friday Challenge is up to you and your wildest imagination.
An Excel chart newbie posted this data set and wasn’t sure the...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...