Forum Discussion

Roger1981's avatar
Roger1981
Copper Contributor
Jul 02, 2021
Solved

Plot isn’t showing up on my chart in excel

Hello everyone! Need your guidance for the below pls. 1. Device and OS Platform: Mac/macOS Big Sur version 11.4 2. Excel product name and version number: Office 365 and 16.50(21061301) 3. ...
  • Riny_van_Eekelen's avatar
    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.

     

Resources