Excel Dashboard Templates

There is a Facebook post going around and I thought it would be a fun Friday Challenge edition.   What is your answer to this this question? Then put in the formula into Excel and see what...

Recently, a fan asked for some help.  However, when I got their file, I saw that they needed some help with basic concepts, so I thought I would share those concepts with you. Now, let...

Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart   Here was my solution that this post references: pipeline-challenge-matching-stacked-bar-chart-colors-to-products-without-vba   Leonid modified the 2 formulas...

As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook.  However, if you create more tabs than you can see on the bottom of...

In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is not date based, but time based.  The use case is...

I was recently asked for assistance with this request: Hi Steve, I am trying to make a hypnogram with data that we collected over the course of a day. I want the y-axis to denote wake...

In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set.  They were confused on what type of chart to make and...

In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products.  You can check out the challenge here: Original Challenge: friday-challenge-pipeline-usage-chart We had a number of great...

I had some great responses to the last Friday Challenge, so I didn't want to stop the momentum with my answer to the last challenge, so I will post that next week.  So here...

Here is a late entry :) Thanks Leonid.  This is an Awesome response! Leonid was responding to this recent challenge:  Friday Challenge – Pipeline Usage Chart   Leonid's Solution: Essentially, this solution is a Clustered Column Chart.  However,...