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 Dynamic Excel Dashboard Charts Using Tables

For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates...
Chart of Tiger Woods Victories on PGA Tour and in Majors

Tiger Woods PGA Tour and Major Championship Chart

I am a fan of the PGA and Tiger Woods.  So I was really excited when I saw this post from Paresh Shah of...

Create Dynamic Excel Chart Conditional Labels and Callouts

Create Dynamic Excel Chart Conditional Labels and Callouts

Chart Conditional Labels and Callouts Learn how to make the simple and easy these Excel Chart Label Callouts:In my most recent article, I described how...

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...



Friday Challenge – Mimic Newspaper Chart Line Style in Excel

Hi All,Here is a fun challenge that I thought you might like.  I  saw this chart in the Denver Post and I wondered how...
Excel Dashboard Template Step-by-Step Tutorial and Sample File

Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart

In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will...

How-to Make an Excel PickList Chart for Multi Years by Month

Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month.You can read more about the original...

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 Eliminate Statistical Outliers in an Excel Line Chart

Okay, I posted this Excel Chart Challenge on Friday.  How did you do?  I am sure your solution is better than mine.  This was...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link