New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting
Excel Flash Fill
Every time a new version of Excel is released there are always new features that are hard to find and learn for those...
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...
Friday Challenge – Recreate Pete’s Bullet Chart
Our good friend Pete sent me his take on the Recent Bullet Chart posting. I was dumb founded on how he created it. In...
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...
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...
Friday Challenge Answers – Food Donation Excel Dashboard Chart
Last week we presented a chart challenge to see how you represent Food Donation data.
Don said that we should keep it simple and sent...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
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...
Show Only Selected Data Points in an Excel Chart
So last week I posted this question in the challenge:
Here the user story on what we are trying to do:
‘As an Excel user I...
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4...
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart...
