Excel Super Bowl Statistics Dashboard
A great big shout out to Don who submitted the best Excel Dashboard of Super Bowl Statistics.
It has a neat design and uses picture...
Friday Challenge Answers – Food Donation Excel Dashboard Chart
Last week we presented a chart challenge to see how you represent Food Donation data.
Don said that we should keep it simple and sent...
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,...
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...
IMDB Top 250 Movies of All Time – Excel Dashboard Tutorial
In our last Friday Challenge, we presented a data set of the Top 250 Movies from IMDB and asked you to create a dashboard...
How-to Make a Sales Pipeline Funnel Excel Chart Template
You probably have seen this type of Funnel Chart in Business Intelligence (BI) software packages and wondered how-to make this type of chart in...
Super Bowl Excel Dashboard Challenge
Here in the United States, we will have the Super Bowl a week from Sunday. It is a really big deal for the country...
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts:
I showed you how to setup your data in preparation for creating a dynamic dashboard chart
Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
And then I...
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...
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...
