If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to show chart only within worksheet?
Does anyone have any suggestions on how to show chart only within worksheet?
I receive a excel file, within a sheet, there is only one chart, and no cell can be selected in other region. Does anyone have any suggestions on how it can be done in Excel 2003? Thanks in advance for any suggestions Eric |
#2
|
|||
|
|||
How to show chart only within worksheet?
Lock all the cells (part of cell format) and then lock the worksheet?
On Sat, 2 Jan 2010 02:47:01 -0800, Eric wrote: Does anyone have any suggestions on how to show chart only within worksheet? I receive a excel file, within a sheet, there is only one chart, and no cell can be selected in other region. Does anyone have any suggestions on how it can be done in Excel 2003? Thanks in advance for any suggestions Eric Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
#3
|
|||
|
|||
How to show chart only within worksheet?
Could you please telll me how to lock cells and worksheet within Excel 2003?
Thank you very much for any suggestions Eric "Tushar Mehta" wrote: Lock all the cells (part of cell format) and then lock the worksheet? On Sat, 2 Jan 2010 02:47:01 -0800, Eric wrote: Does anyone have any suggestions on how to show chart only within worksheet? I receive a excel file, within a sheet, there is only one chart, and no cell can be selected in other region. Does anyone have any suggestions on how it can be done in Excel 2003? Thanks in advance for any suggestions Eric Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins . |
#4
|
|||
|
|||
How to show chart only within worksheet?
http://office.microsoft.com/en-us/ex...CL100570551033
shows how to unlock all the cells. You should reverse the process. The link above also shows how to unprotect / protect the sheet. On Sat, 2 Jan 2010 15:53:01 -0800, Eric wrote: Could you please telll me how to lock cells and worksheet within Excel 2003? Thank you very much for any suggestions Eric "Tushar Mehta" wrote: Lock all the cells (part of cell format) and then lock the worksheet? On Sat, 2 Jan 2010 02:47:01 -0800, Eric wrote: Does anyone have any suggestions on how to show chart only within worksheet? I receive a excel file, within a sheet, there is only one chart, and no cell can be selected in other region. Does anyone have any suggestions on how it can be done in Excel 2003? Thanks in advance for any suggestions Eric Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins . Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
#5
|
|||
|
|||
How to show chart only within worksheet?
Thank you very much for suggestions
I get a sample worksheet, which contain a chart only and refer the data from another sheet. It seems to me that the worksheet is locked except the chart, so I still can select any item within the chart. On the other hands, if I lock this worksheet, everything is locked including the chart. Do you have any suggestions how to lock the worksheet except the chart area? Thanks you very much for any suggestions Eric "Tushar Mehta" wrote: http://office.microsoft.com/en-us/ex...CL100570551033 shows how to unlock all the cells. You should reverse the process. The link above also shows how to unprotect / protect the sheet. On Sat, 2 Jan 2010 15:53:01 -0800, Eric wrote: Could you please telll me how to lock cells and worksheet within Excel 2003? Thank you very much for any suggestions Eric "Tushar Mehta" wrote: Lock all the cells (part of cell format) and then lock the worksheet? On Sat, 2 Jan 2010 02:47:01 -0800, Eric wrote: Does anyone have any suggestions on how to show chart only within worksheet? I receive a excel file, within a sheet, there is only one chart, and no cell can be selected in other region. Does anyone have any suggestions on how it can be done in Excel 2003? Thanks in advance for any suggestions Eric Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins . Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins . |
Thread Tools | |
Display Modes | |
|
|