Chart not showing results from formula

[hayestrent]

Good morning, everyone.
I have a spreadsheet (attached) that has a formula, which calculates the number of days between two dates if another field contains data. My problem is that when I chart the data, it isn't showing up in the chart. Cell G1 (Tab 1) contains a 1 because the document was returned 1 day late. This isn't showing up on the Chart (Tab 2). Please take a look and let me know what I need to change to make this work.

[MrShorty]

You're concatenating an empty string to the 1 value -- making the entire cell value a text string. Excel treats text strings as 0 when charting. For numbers that you want to show up on the chart, make sure the result is a number and not a text string. This might be as easy as eliminating the & "" from the calculation.

[hayestrent]

Thank you! That fixed the problem