Sparklines (Gap for blank "" cells)

[Mahmoudelnemr]

I am using a formula IFERROR(Value, ""), so it turns error values to blank, but when using sparklines excel reads these cells values as zero not gap

in attached pic i want the cell highlighted with yellow to appear as a gap in the sparkline

any solution for that ?

SPAR.png

[JeteMc]

Perhaps this will help.
Do not wrap the calculation in IFFERROR, allow errors to display.
Select the entire data set. In the example shown above select D:I
Press the F5 key
Select special
Select Formulas
Make sure that only Errors is selected under Formulas
Select OK
Press the Delete key
Let us know if you have any questions.