Create a Excel Gantt Chart to Display a Music Festival Band Schedule
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...
How-to Fix Sales Goal Error of Excel Thermometer Chart
How-to Fix Sales Goal Error of Excel Thermometer Chart
I have to admit that I messed up and presented a broken solution for the Excel...
Dashboard Chart of Tiger Wood’s Money Ranking List and Golf Earnings
With the upcoming Open Championship (also known as the British Open) in Royal Lytham & St. Annes Golf Club, I wanted to see how...
Chart Increase at Time Interval in Excel
Here is my answer to the most recent Friday Challenge. Would welcome any comments below on what you think (flaws, likes, thoughts…)
In case you...
3 Ways to Make Excel Chart Horizontal Categories Fit Better
Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable?
Check out this chart to see what...
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...
Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge,
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
where a user wanted the following:
Creating a graph of...
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel
Excel is awesome because, even when a certain chart type is not a standard option, there may be...
Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...
Friday Challenge – Part 2 Removing Gaps from a Clustered Column Chart
Okay Excel Fans, in a previous challenge, we had a problem that we solved for a specific data set. We wanted to remove white...
