Wont show data (resulting from a formula) in a graph

Hi there,

My first post here. I`m posting after googling and doing a bit of searching on this forum.. can`t find anything.

2 simple columns = 'Date' & 'Number'. Cell formatting 'date' & 'number' respectively. For 'Number' Column data comes from a formula '=IFS(H3>=1,"180",H3<=0,"0")' [the H column referenced is another column (cell format 'number') where i manually enter numbers.

When i try to graph 'Date' & 'Number' it I get horrendously chosen axis (obv depends which chart i pick) and the actual graph itself is empty.

Untitled.png

Now if I remove the formula and switch to manually entered numbers it works like a dream.

Originally I tried to graph 4 variables (3 y axis) but no luck so I tried (as shown above) simpler x vs y graph and still nothing. My assumption is once I get the x v y to work i`ll manage with the 4 variable one.

Any idea why my chart doesnt show data resulting from a formula but will happily chart manually entered data?

Brilliant, it does work!

Thanks a lot.