Forum Discussion

lcz2103's avatar
lcz2103
Copper Contributor
Feb 10, 2019

Add Chart Element (along with other functions) not working

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"

excel

6 Replies

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Feb 10, 2019

    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.

    • jeno_'s avatar
      jeno_
      Copper Contributor
      May 16, 2019

      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!

      • Eva Vogel's avatar
        Eva Vogel
        Iron Contributor
        May 21, 2019

        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.

Resources