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

26
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

4
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

1
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...
Better Format for Excel Chart Secondary Axis Columns Overlap with 3 Series

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

28
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...