Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
In this recent post:
Friday Challenge Answers – Cumulative Events Over Time
I created a formula that referenced a table. As I created my video I...
How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings
Recently I saw this in the MrExcel Forums. The title “Weird Charts with 3 Axis” intrigued me.
I determined that they were looking to put...
Excel Pranks: Non-VBA Edition 1
We should have some fun as it is the start of a long weekend and the end of summer.
So what better way to have...
Advanced Excel Summation Techniques Using Pivot Table
There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn...
How-to Fake an Excel Chart Data Table
Fake an Excel Chart Data Table
Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...
How-to Make Conditional Label Values in an Excel Stacked Column Chart
Recently I was thinking that sometimes when you make a Stacked Column Chart in your Excel Dashboard, you may want to hide some of...
How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component
Time for some beer and Excel. Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...
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...
Find And Replace from a List of Multiple Emails in Excel without VBA
Find And Replace from a List of Multiple Emails in Excel without VBA
I had a recent request from a friend who needed to Find...
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?
Notice how the...
