Quantcast

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...
Fix Error Current Sales Greater than Sales Goal - Thermometer Chart in Excel

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

0
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...
Overlapped Horizontal Categories

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

82
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...
Final Stacked and Non Stacked Clustered Column Chart

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

6
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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link