Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

How-to Create and Copy a Table in Google Mail (Gmail) from Excel

30
On a recent project of mine, I tasked a team member with creating a communication to send out to users.  This communication involved making...

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...
Sample File of Excel Template Dashboard Tutorial Offset Function

This is the Bomb: or How I came to love the Offset function

7
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...

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

How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside

4
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced...

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...
How-to Add Edges to Excel Area Charts

How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart

How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart A stacked area chart displays an area of points above other data points...

Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...

A fan of the blog asked a question about this post: Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...

Multi-Column Stacked Chart – How would you do it? – How I did it.

3
First, I want to say thank you, because you are an Excel fan.  Then again, maybe you are an Excel Geek?  I know I...