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...
A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series
Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series.
The Problem
I didn’t love the last chart we...
How-to Draw a Straight Line with Excel Shapes
Have you ever tried to draw a straight line in Excel only to get frustrated?
It can be so Frustrating :) to be off by...
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...
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel
Excel is awesome because, even when a certain chart type is not a standard option, there may be...
How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip.
The...
Find and Replace Error In An Excel Spreadsheet
I have just started on a new project and I ran across this error or should I say issue? Maybe you have seen this...
Friday Challenge – Data Transformation Solution
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...
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...
Friday Challenge – Close the Distance Between a Clustered Stacked column Chart
For this week’s challenge, we are going to modify a previous post for a user request.
If you are not familiar with it, you should...
