Budget Analysts – How would you answer this Excel Chart question?
Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive...
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...
Excel Dashboard of the Top 250 Movies – Don’s Friday Challenge Entry
Here is our next submission from the last Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel Dashboard...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
How-to Make a Thermometer Goal Chart in Excel
How-to Make a Thermometer Goal Chart in Excel
A friend and co-worker asked me if I had a tutorial on a building a Thermometer Goal...
Group Column Chart with Lines for Excel Dashboard Presentations
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...
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...
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...
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...
How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com. The graph describes how many people use...
