Excel Dashboard Templates

I am sure you have created a Pivot Table in your Excel Workbook.  However, have you wanted to easily learn how to add a calculated field?  It is not too hard, but it is...

Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating :) to be off by one or 2 pixels.   Well Excel has the solution and you...

A while back, I published an article on how to make an Area Cliff Chart. Now this isn’t a standard chart type. If you use the Standard Excel Area Chart with blank data, Excel will interpolate the...

Do you want your Excel charts and dashboards to really stand out at your company? Well then you should start using custom colors in all your graphs. It is really simple, but some people do not...

Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts.  I recently saw a post asking for this help: "Please advise if it is possible to combine a pivot line...

We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have fun than with some pranks.  And better yet, Excel Pranks. I...

In Excel, you will frequently have text that is longer than the cell width and you will often use the Wrap Text feature to make it more readable. However, have you ever had a row...

  Today I have 2 formula challenges that you may find interesting.  They are both different types of allocation formulas.   Challenge 1: Problem: You have 9 tasks that each take a different amount of time to complete. ...

When you have several series in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the labels as the default will appear in their own series...

Here is Pete's answer to the recent Music Festival Schedule Challenge. In this video, see how he used Index/Match functions as well as a helper row to create an easily expandable chart data set. Here is...