SOLVED

graphs in excel on line with office365

Copper Contributor

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?

4 Replies
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.

Thank you @Jan Karel Pieterse 

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

 

JakeM80_0-1626684590115.png

Much appreciate your thoughts and assistance

Jake

best response confirmed by allyreckerman (Microsoft)
Solution
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.

Yes it seems you are correct... I spoke to Microsoft help desk and they said the same that Excel for Android is not so advanced and some things cannot be done! :( thank you @Jan Karel Pieterse 

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution
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.

View solution in original post