Olympic Medal Count Dashboard
So the summer Olympics start this week. So I thought it would be a good time to visit how one might create an Olympic...
How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard
Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...
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...
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 Make a Non-Chart Excel Dashboard Chart (Heat Index)
So I saw this chart in an Excel forum and a user was asking this:
“chart - not sure about this one
I've created a...
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 a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced...
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...
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
This is part 1 of creating a dynamic Excel dashboard chart using the scroll bar control.
So in the title I said that we would...
