Jul 01 2021 06:27 PM
Jul 01 2021 09:40 PM - edited Jul 02 2021 01:01 AM
Solution@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.
Jul 02 2021 03:24 AM
Jul 01 2021 09:40 PM - edited Jul 02 2021 01:01 AM
Solution@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.