Another Reason to Avoid 3-D Charts in Excel
Many Excel Dashboard creators like to like to use 3D Charts in Excel presentations. However, there can be many problems when you choose to...
How-to Quickly Mock-up Data for a Dashboard Template
I frequently need to create and test a chart design concept for Excel Dashboards. Therefore, I need chart data that is representative of the actual data,...
Top Movies – Excel Dashboard – Brian’s Friday Challenge Entry
This was our final entry in the most recent Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel...
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...
Practice Makes Perfect Excel Dashboards and Charts
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...
Titanic Mortality Dashboard
Today marks the 100th anniversary of the tragic sinking of the RMS Titanic. On that fateful day, over 1,500 people died when the Titanic...
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 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 Make Conditional Label Values in an Excel Stacked Column Chart
Recently I was thinking that sometimes when you make a Stacked Column Chart in your Excel Dashboard, you may want to hide some of...
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...
