How-To

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...

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...

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...

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...

Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts. However, he originally created the...

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...

I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...

A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel. It...

In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart And then I...

In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post, we explore the...