How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save...
How-to Add Resource Names to Excel Gantt Chart Tasks
How-to Add Resource Names to Excel Gantt Chart Tasks
I recently received a request from a fan that asked how he could add resource names...
Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers
In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set. They...
How-to Make a Wall Street Journal (WSJ) Double Lollipop Chart in Excel
In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ).
Here is what our final chart...
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge.
Here was the original Challenge:
friday-challenge-pipeline-usage-chart
Here was...
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 Make an Excel Stacked Area Chart Cliff
A while back, I published an article on how to make an Area Cliff Chart.
Now this isn’t a standard chart type.
If you use the Standard...
How-to Easily Add Task Information to Excel 2016 Gantt Charts
Easily Add Task Information to Excel 2016 Gantt Charts
Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted...
How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)
In are recent post, I showed you how to create a Bullet Chart in Excel. Pete, then sent me another way to create a...
Change Chart from Amount to Percent using a Drop Down List
In case you were wondering, here is my solution to last Friday’s Excel Challenge.
Our challenge was to see if we could solve this question...
