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

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

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

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

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



How-to Create a Dynamic Banding on an Excel Line Chart

This dynamic shading or banding chart is frequently used in science and in Company Dashboards.  It allows the user to quickly see if their...
Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

The Problem Recently a fan contacted me and asked how she change the horizontal axis could do the as follows: "I am trying to bold 5...

Friday Challenge Answers – The Boss Says…

I received some great responses from lots of fans.  Thank you so much for all your great comments.  I agree with most and my...



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