Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show chart only? | Excel Discussion (Misc queries) | |||
Show Zeros in some cells even though worksheet set to not show zer | Excel Discussion (Misc queries) | |||
how do i sort a worksheet data to show repetitve data and show | Excel Worksheet Functions | |||
do not show zeros in pivot chart (pie chart) | Charts and Charting in Excel | |||
How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel |