Table

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

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates...

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

Yesterday, I showed you how you can use the new label options in Excel 2013 to help Kevin with his engineering chart.  But we...

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

Fake an Excel Chart Data Table Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...

On a recent project of mine, I tasked a team member with creating a communication to send out to users.  This communication involved making...

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

In our last Friday Challenge, Friday Challenge – Showing More Categories in an Excel Chart we were trying to help Kevin with his problem. He had followed...