Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List
Before we begin, I am going to show...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)
In are recent post, I showed you how to create a Bullet Chart in Excel. Pete, then sent me another way to create a...
How-to Easily Create a Stacked Clustered Column Chart in Excel
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...
How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Sum Excel Worksheets Technique
Why haven't I known about this simple Excel technique before now?
Maybe you were aware how you can easily Sum Excel Worksheets...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
How-to Group and Categorize Excel Chart Legend Entries
If you have a chart with Legends, then you should check out this tutorial.
Recently when working on a solution for a fan, I noticed...
How-to Create a New York Times Tiger Woods Chart in Excel
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times. Here is the chart...
How-to Convert an Existing Excel Data Set to a Pivot Table Format
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...
How-to Put Percentage Labels on Top of a Stacked Column Chart
There are times when you are creating your Excel Dashboard Design that you desire something that does not come naturally with the Excel Tools...