How-to Make a Conditional Column Chart in Excel – REDO
·
In a previous post, I showed you how to make a Conditional Column Chart for your Executive Dashboard Templates, but I had 3...
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...
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 Add Specific RGB or HSL Colors in Your Company Chart or Dashboard
Do you want your Excel charts and dashboards to really stand out at your company?
Well then you should start using custom colors in all...
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...
How-to Make Dynamic Excel Dashboard Charts Using Tables
For almost every Excel Dashboard you will want to make a Chart template Dynamic. Meaning that as you add new data, the chart updates...
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...
Using the Camera Tool to Create a Vertical Line Chart in Excel
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...