Forum Discussion

SJPfister's avatar
SJPfister
Copper Contributor
Jan 11, 2022
Solved

Plotting data with formulas that result in a blank or empty cell

Hello I am trying to figure out how to create gaps in a line chart where the data is blank.  The data I am trying to plot is based on formulas, for example:  =IF(SUM(Calc!N5:N57)=0,"",SUM(Calc!N5:N5...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 11, 2022

SJPfister 

Use NA() instead of empty text and add setting as

  • SJPfister's avatar
    SJPfister
    Copper Contributor
    Jan 17, 2022
    Thanks. That is what I was looking for.

Resources