How-to Add a Line to an Excel Chart Data Table and Not to the...
Many people making Excel charts love to add a Chart Data Table to their graph. However, the Excel Data Tables are not very flexible...
How-to Add Lines in an Excel Clustered Stacked Column Chart
I have posted several Excel chart samples related to Clustered Stacked Column Charts.
In case you missed them, you can check them out here: Excel...
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...
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 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...
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...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
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 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...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...