How-to Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart

Many users like to create a chart that Excel doesn’t have as a chart type.  It is a combination of a clustered column and...

Excel Dashboard of the Top 250 Movies – Don’s Friday Challenge Entry

Here is our next submission from the last Friday Challenge for the Internet Movie Database Top 250. Below you can download an awesome Excel Dashboard...

How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values

I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...

Presenting Metrics Data – How would you create a chart for this data?

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

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...
Create Vertical Line Between Columns in Excel with Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars Thanks to Leonid (a super fan) for advising me on another and possibly better...

How-to Make an Excel PickList Chart for Multi Years by Month

Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month. You can read more about the original...

Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard

1
Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very...
Data Transformation Butterfly Image

Friday Challenge – Data Transformation Solution

In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...