Chart issues

[Constance0818]

Hello, 

My chart is not picking up the correct cell. However, there is data in the cell.

[#2]

I'm not sure what to do now?

[#3]

I have a case reference number if that helps

[#4]

@Constance0818 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

[#5]

@Constance0818 

Most probably these values are entered/formatted as text

Try to check with =ISTEXT(A1) or like taking correct reference instead of A1