Broken Line Excel Chart With Formulas for Linked Chart Data

< Back to Search results

 Category: [Excel]  Demo Available 

Broken Line Excel Chart With Formulas for Linked Chart Data


Got a Excel Chart question? Use our FREE Excel Help!


Non zero data returned from a formula is treated as zero. The use of NA() allows the line to be joined between numeric points

The mask method can be used to create breaks for missing data.

Original Data   Linked Data "" Linked Data #N/A Linked Data Masked Mask
0.28 A 1.28 2.28 3.28 #N/A
0.25 B 1.25 2.25 3.25 3.25
0.01 C   #N/A #N/A #N/A
0.35 D 1.35 2.35 3.35 3.35
0.07 E   #N/A #N/A #N/A
0.87 F 1.87 2.87 3.87 3.87
0.72 G 1.72 2.72 3.72 #N/A
0.88 H 1.88 2.88 3.88 #N/A
0.21 I 1.21 2.21 3.21 #N/A
0.34 J 1.34 2.34 3.34 #N/A
0.40 K 1.40 2.40 3.40 #N/A

The example workbook contains a formula to create the mask data series.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

Creating Bounding Area Within XY Scatter Chart
Broken Axis on an Excel Column Chart


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)