1

Chart only uses data you input, it won't guess and fill the blanks. Thus as a solution recommend using this supporting formula and build chart based on its results: ={SEQUENCE(MAX(A:A)-MIN(A:A) + 1,1,MIN(A:A),1), ARRAYFORMULA(IFERROR(VLOOKUP(SEQUENCE(MAX(A:A)-MIN(A:A) + 1,1,MIN(A:A),1),$A:$B,2,0),0))} It creates sequence of dates starting from the oldest ...


Only top voted, non community-wiki answers of a minimum length are eligible