Chart
How-to Fake an Excel Chart Data Table
In this tutorial, you will see an extended technique on creating a more flexible Excel Chart Data Tables.
EXPLORE THE LIBRARY
Tag: Line Chart
Chart
How-to Show Text in an Excel Chart Data Table (Part 1)
Learn 2 Excel Chart techniques on how you can create a more flexible Excel Chart Data Tables. One that shows how you can put in Text in the data table.
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.
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.
Area Chart
USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights
Use Excel to recreate a USA Today infographic
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.