Excel Dashboard Templates

Well, I have been working hard on my project and it has successfully launched.  But that took time away from my other passion, EXCEL!!! So I started out a few weeks ago trying to make...

Below is a video that may help you as well. How-to make a Dynamic Excel chart that doesn't show blank values so you don't have to use filters. It uses a combination of Index and Match functions...

I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports.  So I get a lot of free newspapers like the...

While fooling around with Excel, I wondered if I could make an Excel chart look like a the Star Wars Death Star.  Well, I think I was able to create a pretty good Excel...

Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very well recently.  And that got me thinking, in July of...

Hi All, I wanted to send out a quick post to my subscribers and fans. Thank you very much for your support and I hope you have enjoyed the postings and tutorials on this site. If you...

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of chart.  What could it be? Excel does not offer a Clustered...

Time for some beer and Excel.  Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their company in order to track progress toward a celebration.  Today,...

I have seen many questions where an Excel users want to know more about how to create a Gantt Chart using Time instead of Dates.  Here is another example of such a request.   The...

Many people making Excel charts love to add a Chart Data Table to their graph.  However, the Excel Data Tables are not very flexible and most people stop using them.  But in this tutorial,...