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...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
Using the Camera Tool to Create a Vertical Line Chart in Excel
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...
How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis
In this previous post:
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis
I had a fan question - How...
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 Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue
Check out this simple technique if you have pressed the wrong keys on your keyboard and can't stop Excel from scrolling instead of moving...
Creating Excel Stacked Column Chart Label Leader Lines/Spines
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart.
You can check...
How-to Make a BETTER Excel Sales Pipeline or Sales Funnel Chart
Learn how to make an accurate sales pipeline in Excel. In previous posts, I have showed you how to make a sales funnel chart...
How-to Select Data Series in an Excel Chart when they are Un-selectable?
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...