Things You Probably Didn’t Know About Excel
I am getting old . We all are every second of the day .
But, my spreadsheet experience pre-dates Excel. Time to take the WAY...
Fastest Way to Open a New Workbook in Excel
I saw in a recent post on Contextures.com, that Excel 2013 has added new option that you can choose to not display the start...
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the...
How-to Connect Gaps in a Line Chart in Excel
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete. For instance, you may...
How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart
Sales executives are always pushing their sales teams. They typically do this by setting sales quota’s for their salespeople. Quotas are thresholds or minimum...
How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...
Remove The Zero Point or Make a Hole in an Excel Radar Chart
As my lovely wife recently stated, Excel Radar Charts are COOL! I kind of agree.
That is why when I recently saw an Excel question...
What are the first and last dates in Excel?
Have you ever considered “What is the last date that Excel can show?” or “What is the first date that Excel can show?”
I thought...
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...
How-to Make an Excel Area Chart Cliff (Fiscal Cliff Edition)
So all the US news agencies keep talking about the Fiscal Cliff. This reminded me of a problem that many people have when making...
