Axis Formating
How-to Make a Pass Fail Chart in Excel
Step-by-Step Tutorial on making a visual representation of Pass / Fail data in an Excel Chart.
EXPLORE THE LIBRARY
Line Chart
Connect Line Data Points
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
Learn how to have gaps in a line chart when using the NA function in an Excel Formula
Chart
How-to Eliminate Statistical Outliers in an Excel Line Chart
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
Challenge
Friday Challenge – Eliminating outliers in and Excel Chart
how to make an excel chart that ignores outliers when plotted in a line chart. Do this without manually deleting the data points.
Area Chart
How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard
How to use a pick list to change the chart type for your excel dashboard graph
Column Chart
How-to Create a Sick Leave Excel Dashboard Chart
Learn how to use custom markers and offset formulas to create a sick leave chart for an Excel Dashboard.
Chart
How-to Add a Line to an Excel Chart Data Table and Not to the Excel Graph
how to video and step-by-step tutorial on creating more data table rows in an Excel Chart without adding more lines in the line chart.
Chart
Excel Line Charts Using a Date Axis
How Excel charts are drawn using date category labels for the horizontal axis in charts and graphs
Banding Horizontal
How-to Create a Dynamic Banding on an Excel Line Chart
Tutorial to make a confidence band in an Excel Line chart to shade a range to highlight thresholds in a Comany Dashboard Chart
Connect Line Data Points
How-to Connect Gaps in a Line Chart in Excel
How to connect Excel line charts when you have missing data, gaps in data or blanks in data.