WebMay 6, 2024 · Can't create chart, option grayed out Using Excel Home and Business 2013 Version 15.0.5023.1000. Just updated it now. I had this same problem with an old spreadsheet, where suddenly I could no longer add new data to the chart. So created … WebClick any cell in the table. Click Insert > 3D Map. (Clicking 3D Map for the first time automatically enables 3D Maps.) 3D Maps uses Bing to geocode your data based on its geographic properties. After a few seconds, the globe will appear next to the first screen of the Layer Pane. In the Layer Pane, verify that fields are mapped correctly and ...
Excel 2013 insert chart greyed out in documents created in Excel 2010
WebMar 6, 2024 · 2016. Platform. Windows. MacOS. Feb 12, 2015. #2. Perhaps: File - Options, Advanced section: scroll about half way down and make sure that in the "Display options for this workbook" section, the "For objects show:" option is set to All and not Nothing. 0. WebNov 29, 2006 · I need to add a text box to a chart but the text box icon is greyed out on the drawing toolbar, as are the other addition icons, line box etc. The icons are also greyed out on the non chart worksheets. Other workbooks do not have this problem. I have tried removing and adding the drawing toolbar to no effect. crypto hedge fund marketing material
Change the data in an existing chart - support.microsoft.com
WebJun 20, 2024 · 1. Click on File and click on Options. 2. On the left side click on “Advanced”. 3. Scroll down to the “Display options for this workbook:”. 4. Locate “For objects, show:” 5. … WebClick the chart area of the 3-D chart that you want to change, or select Chart area from the Chart elements list under Current Selection on the Format tab. Keyboard shortcut You can, instead, click the chart area, and then press CTRL+1. Continue with step 3. On the Format Chart Area dialog, click 3-D Rotation. WebJan 9, 2016 · I have set up a spreadsheet with formulas but the Pivot Table button is greyed out. Certain cells are protected, and the Pivot Table button will only display if I Unprotect Sheet, but is there a way to set up a Pivot Table with a protected sheet? I … crypto hedge fund software development