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...
How-to Create Dynamic Excel Dashboards Using Picklists
This is a great technique that you can use to create dynamic charts that will change when your users change the values from the...
How-to Build a Plan vs Actual Excel Dashboard
Hi All, I wanted to share with you a great post from a fellow Excel creator and teacher. Mynda Treacy has just released 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...
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...
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste...
How-to Make a Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data.
Read it over, but really, the last line of the...
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my...
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?
Notice how the...
