![]() |
|
#1
|
|||
|
|||
|
I am trying to add a new chart in a new worksheet in a protected workbook, but the "plus sign" to add a new sheet is grayed out, so I can't add the sheet. Thanks for any help. |
|
#2
|
|||
|
|||
|
I mostly do as bellow:
It is possible to create a new sheet for you chart, if you first select the data range then go to insert chart. Select chart type then In the chart Options window select new worksheet. |
|
#3
|
|||
|
|||
|
Unprotect the sheet.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet
|
safrac | Excel | 17 | 10-04-2022 12:21 PM |
I need an index file containing the names of all the worksheets in a workbook.
|
retiredstuart | Excel | 3 | 09-12-2014 06:26 AM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Select a range in one one workbook while working in other workbook
|
Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |