The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
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...
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...
How-to Create a New York Times Tiger Woods Chart in Excel
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times. Here is the chart...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
Creating Excel Stacked Column Chart Label Leader Lines/Spines
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart.
You can check...
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...
2008-2012 Summer Olympics Medal Count Dashboard Part 2
Wow, what a Summer Olympics. the 2012 medal count is so close. China and the USA are neck and neck in terms of total...
The Absolute Quickest Ways to Make a New Chart in an Excel Spreadsheet
When creating my Microsoft Excel Dashboard Templates, I frequently create a chart to see how it would look and I don’t always keep them. ...
Dashboard Chart of Tiger Wood’s Money Ranking List and Golf Earnings
With the upcoming Open Championship (also known as the British Open) in Royal Lytham & St. Annes Golf Club, I wanted to see how...