How-to Make a Sales Pipeline Funnel Excel Chart Template
You probably have seen this type of Funnel Chart in Business Intelligence (BI) software packages and wondered how-to make this type of chart in...
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...
Case Study: Executive Dashboard Chart Creation – Follow-up
The Problem
In a recent post:
“Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612)
I presented some basic data that you may have in your company that you...
Company and Industry P/E (Price to Earnings) Line Chart – 2 Ways
Here is a fun and easy Dynamic Excel Chart that you can use in your Excel Dashboard Template.
This Excel Chart has many financial research,...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
Dashboards are Everywhere!
Dashboards Can Be Found Everywhere
I am presently in Suzhou China working on a new project and I decided to go to the gymnasium. I...
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?
Notice how the...
How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
How-to Add Specific RGB or HSL Colors in Your Company Chart or Dashboard
Do you want your Excel charts and dashboards to really stand out at your company?
Well then you should start using custom colors in all...









