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...
How-to Create a Combo Line and Column Pivot Chart
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help:
"Please...
How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip.
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 Make an Excel Project Status Spectrum Chart
Here is the long awaited demonstration of a recent Friday Challenge.
The challenge was to recreate a Project Management Status Chart that I saw on...
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save...
Presenting Metrics Data – How would you create a chart for this data?
In my last post I asked how you would create a chart for this request:
Presenting Metrics Data
Trying to find the best way to...
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...











