Forum Discussion

Dave0122's avatar
Dave0122
Copper Contributor
Nov 18, 2024

Most of my chart options are greyed out

Hi!

I made a box plot with some data and most of the options on the Chart tab are greyed out.  All of the editing / toolbar options are available on the tab with the data, however.  I have tried the following to correct this:

-My workbook is unprotected

-It is not shared

-My tabs are not grouped

-I have no active/working cells in the data tab

-Under Advanced -> Display the 'All' box is selected under 'For objects, show:'

-I cannot manually add the text box 

-I have cut and pasted the data into a new spreadsheet and the chart options are still greyed out

-Options are greyed out regardless of the chart plotted

-I've tried Ctrl+6

 

-The file is saved as a .xlsx

 

Any other troubleshooting options would be greatly appreciated.  Happy to answer any questions about any other setting I may have overlooked.

 

Thanks so much!!!

 

Dave

 

 

  • Please check on active filters, add-ins and object selections in first place

    • Dave0122's avatar
      Dave0122
      Copper Contributor

      Hi,

      Can you elaborate on this please?  What, exactly, am I checking?

      Thanks - Dave

Resources