Feb 09 2019 08:38 PM
Is there a figure out why I cannot click on Add Chart Element? I have made a scatterplot from a data table, but cannot edit this graph because Excel is not allowing me to click on "Add Chart Element"
Feb 10 2019 12:25 AM
Hello @lcz2103 ! Maybe your worksheet is broken. Try to save it, open it again. On my side it works. Send a screenshot pls. if you get an error message. Greets, Eva.
May 15 2019 06:58 PM
@Eva Vogel I'm encountering the same problem. I've tried on several workbooks, restarted my laptop, without success. When I create a scatter plot, the Add Chart Element button appears, but when I click it, no drop down menu appears. Any thoughts? Thanks!
May 21 2019 12:23 AM - edited May 21 2019 12:27 AM
Hello @jeno_! Sorry for my late answer. Would be helpful to get a screenshot of your workbook and that scatter plot you can´t edit.
Possible causes i can imagine: Do you have an Excel 16 oder 19 workbook without compatibility mode? Pls. check your File informations on Tab "Home" - Informations.
Other cause could be: is your sheet shared with others? I opened again that testfile i made on Feb 19 and saved it on my OneDrive. But I tried to open it on Windows 10 with another account, so my OneDrive asked me (right-click option as an author of that file says: "grant access to==> delete access), if I am willing to stop the sharing of that file on OneDrive. Maybe that file is in checked out mode with others. If you are not the author of that file: pls. ask them to check in again that file, so that you can work with it with your "Edit" permission. This could be the case on OneDrive or SharePoint.
Look again at your Home Tab of that file and check the Informations there. Or: you dont have permits to get into that chart to edit it. This permissions also have to do with wether it is a saved path on OneDrive or SharePoint and who is the author of that file. The author can restrict editing by share a file on that platforms with certain permissions like "only read". Or: Pls. send a screenshot. Hope that helps on your side. Greets, Eva.
May 27 2019 09:44 AM - edited May 27 2019 09:47 AM
@Eva Vogel Thanks for your reply. My chart isn't shared. I'm simply opening Excel and filling in a few cells to make a scatter plot. I've attached a screen shot. When I get to this point, I'm unable to click on the Add Chart Element button. No drop down comes up.
I looked and my excel is version 15.15. I have an office 365 subscription, so I thought I would have the most up to date version. I'm not sure what else could be happening.
Thanks for your help!
May 27 2019 10:22 AM
May 27 2019 11:41 AM
Dear @jeno_ ! That's always great to find a way on your own, so happy to have assisted a bit! Have a good week and have fun with your Excel 365 :)
All the best,
Eva.