Graph not populating data points

[crburke92]

Hi all,

Having some issues getting a graph to plot data points. I currently have this graph working on an older version of this form so I'm not sure what's going on. Img1 shows my table which is formula driven. Only the first column (I) of data is populating the graph as shown in Img2. The proceeding numbers are registering as 0's and aren't plotting, however my date along the X axis is. Img3 shows my data selection.

I initially just tried to build the graph from scratch but it gave me this issue. I then copy and pasted the old graph into this file, and refined the formula to not reference the old sheet, but had the same outcome. Any help is much appreciated!

 

[mole999]

The second graph down seem only to show 1 date, can't really tell from here 1.9 1.6 etc

 

[crburke92]

Sorry by dates I mean along the X axis, not the points themselves. 1.9 and 1.6 are values from 2019, next point would be 2018...2017 and so on.

In select data, the x axis formula is I20:W20 and they appear fine.

 

[crburke92]

its picking up numbers as 0...