Tag: How-to

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

Recently, a fan asked for some help.  However, when I got their file, I saw that they needed some help with basic concepts, so...

Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart   Here was...

As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook.  However, if you create...

In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...

In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set.  They...