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 Make a Beer Mug Goal Chart as an Excel Dashboard Component
Time for some beer and Excel. Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...
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...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
Group Column Chart with Lines for Excel Dashboard Presentations
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...
Excel Clustered Column Chart Conundrum
Many, many, many Excel users post this problem in user forums. And this one always throws me for a loop and takes me time...
A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series
Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series.
The Problem
I didn’t love the last chart we...
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 Make a Sales Pipeline Funnel Excel Chart Template
You probably have seen this type of Funnel Chart in Business Intelligence (BI) software packages and wondered how-to make this type of chart in...
