Forum Discussion
Plot isn’t showing up on my chart in excel
- Jul 02, 2021
Roger1981 Can't really tell what happened but the numbers in the table weren't recognised as such. They were seen as texts and could thus not be plotted.
Check it in your own file. Type =ISNUMBER(cell) somewhere and points any of the "numbers" in the table. It comes out FALSE, meaning it's not a number.
I entered a formula like =VALUE(B7) in B7 below the graph and copied it four rows down and 49 columns to the right. Then formatted the original data range to "Number" and copied/pasted values from the range with the VALUE formulae on top of the original data range.
See attached.
Roger1981 Can't really tell what happened but the numbers in the table weren't recognised as such. They were seen as texts and could thus not be plotted.
Check it in your own file. Type =ISNUMBER(cell) somewhere and points any of the "numbers" in the table. It comes out FALSE, meaning it's not a number.
I entered a formula like =VALUE(B7) in B7 below the graph and copied it four rows down and 49 columns to the right. Then formatted the original data range to "Number" and copied/pasted values from the range with the VALUE formulae on top of the original data range.
See attached.
Indeed, it was the format of the cell causing this issue. It wasn’t number at all.
The problem is solved and I learnt something new.
Thank you so much and appreciate it.