Excel Goal Chart Filling a Bottle of Soda
In a previous post, and one of my favorites, I showed you a unique company goal chart using a beer mug instead of a...
How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis
In this previous post:
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis
I had a fan question - How...
Friday Challenge – Find Unique Values from CSV List
Welcome back to another Friday Challenge at Excel Dashboard Templates!
Today's challenge is pretty straight forward and can be done manually (although it will take...
How-To Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
Leonid’s Friday Challenge Answer – Pipeline Usage Stacked Bar Chart
Here is a late entry :) Thanks Leonid. This is an Awesome response!
Leonid was responding to this recent challenge: Friday Challenge – Pipeline Usage...
How-to Make a Thermometer Goal Chart in Excel
How-to Make a Thermometer Goal Chart in Excel
A friend and co-worker asked me if I had a tutorial on a building a Thermometer Goal...
Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
How-to Make an Excel Bullet Chart
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance,...
