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

Weird Excel Charts

0
Have you ever seen a chart or graph like this in Excel? I created this chart using Excel the other day. It IS one combined chart...

How-to Create an Excel Combined Chart for Tiger Woods Earning and Money Rank

0
Check out this Excel Combined Chart on how much money has Tiger Woods made over his career and also how did he rank in...

How-to Eliminate Statistical Outliers in an Excel Line Chart

4
Okay, I posted this Excel Chart Challenge on Friday.  How did you do?  I am sure your solution is better than mine.  This was...

3 Ways to Create Vertical Lines in an Excel Line Chart

35
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish.  We...

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

How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard

4
Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...

Friday Challenge – Analyzing Attendance Records with Six Sigma Charts

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

New Chart Label Leader Lines Available in Excel 2013

Did you know that you can now add Leader Lines to your Excel Charts in Excel 2013?  I didn't know this until just recently. ...

How-to Mimic a Newspaper Chart Line Style in Excel

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...