Can't stop graph from displaying non values as a 0

That might not be a great description but basically I have an Excel file that I didn't make but I did modify and I added a column that summed up three other columns and added it into the graph.

The problem is, unlike the rest of the graph, which clears data and then pulls from a website as I update it periodically, the column that I have that is a sum will appear as a flat 0 the whole way unless I delete it all and then drop down the cells as I go.

I think it will be easier to snip the Excel file and show it because I'm sure this will not make a ton of sense.

https://ibb.co/4R9FZCBc https://ibb.co/MxTDLPbC

Does anyone know how to handle this? It's driving me crazy to either have that bottom line there on the graph or have to manually pull down the formula each time I pull in new data..