Excel Dashboard Templates

Many users like to create a chart that Excel doesn’t have as a chart type.  It is a combination of a clustered column and a stacked column.  There are tutorials out that that are...

For this week’s challenge, we are going to modify a previous post for a user request. If you are not familiar with it, you should check out this post first: How-to Easily Create a Stacked Clustered...

Removing Gaps - Excel Clustered Column or Bar Chart (Part 2) In an earlier Friday Challenge, I posted a problem where someone wanted to remove the whitespace from a given data set.  That one turned...

Okay Excel Fans, in a previous challenge, we had a problem that we solved for a specific data set.  We wanted to remove white space in a clustered column chart.  If you don’t remember...

Are you familiar with OCR?  It stands for Optical Character Recognition.  Well in this post I will show you how to copy and paste numbers and text from a picture and paste them into...

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 links to dynamically display the data. Don even added a United...

Don’t worry, Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series to the secondary axis.  And here is how to fix...

Many, many, many Excel users post this problem in user forums.  And this one always throws me for a loop and takes me time to solve it.  So I thought I would send it...

Here in the United States, we will have the Super Bowl a week from Sunday.  It is a really big deal for the country and is growing globally. At least that is what they...

Okay, for the last challenge, Peter went above and beyond and also submitted a VBA solution to this problem.  Great job Peter! Here is how it works: There is a data section, and a calculation section. ...