Bubble Chart
Dynamically Change Excel Bubble Chart Colors
This tutorial will show you how to conditionally format bubble colors in an Excel chart using the NA() function.
EXPLORE THE LIBRARY
Tag: NA() Function
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.
Conditional Chart
Halloween Special – Spider Web, Spider and the Fly Chart
Halloween Chart - How to make a conditional radar chart that uses custom markers to have a spider chase a fly on a web graph