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
EXPLORE THE LIBRARY
Data Series
Chart
The Quickest Way to Select an Data Series in an Excel Chart
If you have you ever had a problem selecting a series in an Excel Chart? This is the quickest way to select a data series that is very difficult if not impossible to select with your mouse.
Array
Protecting Your Excel Charts and Dashboards with Array Formulas
Using Arrays can protect you from getting reference errors when users delete or insert rows or columns in your Excel Dashboards
Axis Formating
How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings
Video Tutorial on How to create a 2 axis chart grouping for your Excel Column Chart
Chart
How-to Select Data Series in an Excel Chart when they are Un-selectable?
How to select a chart series that is not selectable in an Excel Chart or Excel Graph