How-to Make a Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
Removing Gaps in an Excel Clustered Column or Bar Chart (Part 2)
Removing Gaps - Excel Clustered Column or Bar Chart (Part 2)
In an earlier Friday Challenge, I posted a problem where someone wanted to remove...
New Take on the Excel Project Status Spectrum Chart
Leonid, a wonderful reader of our website, sent in a new take on my Excel Project Status Spectrum Chart. Here is what his looks...
Friday Challenge – Pipeline Usage Chart
I recently got a request from a subscriber that asked if I could help them create a cylinder chart. However the sample that was...
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...
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...
How-to Center Excel Clustered Chart Columns Over Horizontal Category Labels
When you have several series
in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the...
2008-2012 Summer Olympics Medal Count Dashboard Part 2
Wow, what a Summer Olympics. the 2012 medal count is so close. China and the USA are neck and neck in terms of total...
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...
How-to Fix an Excel 3D Chart so that it Matches the Gridlines
While working for a company that paid bonuses, the Financial and Human Resources team sent out a chart showing how close we are to...
