Forum Discussion

JakeM80's avatar
JakeM80
Copper Contributor
Jul 18, 2021
Solved

graphs in excel on line with office365

Good afternoon. I have just signed up to office365 and am trying to amend the data range on an existing graph.... but cant seem to find a way to do this? on the usual Microsoft version of excvel I could right click the line on the graph and amend the data range... but this doesnt seem to work? I am using a chrome book... any thoughts [pls?

  • In that case I think this cannot be done (yet) using Excel on-line.
    If you use Excel extensively, anything other than a Windows computer is (still) second-best I'm afraid.

4 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    The only way I can find is by using the "Select Data" button on the Chart tab of the ribbon. And that seems to edit all series rather than just one.
    • JakeM80's avatar
      JakeM80
      Copper Contributor

      Thank you JKPieterse 

      But when I do that I get the following message... even though only one line on the graph is selected?

       

      Much appreciate your thoughts and assistance

      Jake

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        In that case I think this cannot be done (yet) using Excel on-line.
        If you use Excel extensively, anything other than a Windows computer is (still) second-best I'm afraid.

Resources