How-To

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

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

In the recent Friday Challenge: Create Pipeline Usage Chart A user wanted to create a bar chart where the values had a specific color by...

As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives. Typically, company executives...

In this recent post: Friday Challenge Answers – Cumulative Events Over Time I created a formula that referenced a table.  As I created my video I...

This is an awesome guest post from our great friend Pete.  He came up with this awesome technique to make a dynamic pie chart...

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...

In a popular post, I showed you how to easily create a Clustered Stacked Column chart in Excel using Multi-Level Category Axis options. Here is...