Excel Dashboard Templates

I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart.  You can see the tutorial and video demonstration of this technique here: How-to Put Percentage...

When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete.  For instance, you may have dates, but no corresponding data for the dates in...

Sales executives are always pushing their sales teams.  They typically do this by setting sales quota’s for their salespeople.  Quotas are thresholds or minimum targets that they expect their sales people to achieve during...

Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph.  However, this Excel Trick showed you how to make a longer color...

How-to Create a Dynamic Excel Pie Chart Using the Offset Function Recently, I viewed a forum post where a user wanted to create a dynamic pie chart that will change the series based on different...

As my lovely wife recently stated, Excel Radar Charts are COOL!   I kind of agree. That is why when I recently saw an Excel question posted in a forum it peaked my interest.  The user...

Excel can do some crazy things to your Dashboard Templates, Charts and Graphs, but most of the time we just roll with the punches.  But have you ever wondered why Excel does what it...

Have you ever considered “What is the last date that Excel can show?” or “What is the first date that Excel can show?” I thought of this posting after reviewing a Datapig blog post that...

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the data that was to be used in the charts, and...

So all the US news agencies keep talking about the Fiscal Cliff.  This reminded me of a problem that many people have when making an Area Chart.  Given this data: I have seen several posts...