Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 2nd 10, 10:47 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,670
Default 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   Report Post  
Old January 2nd 10, 05:25 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 126
Default 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   Report Post  
Old January 2nd 10, 11:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,670
Default 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   Report Post  
Old January 3rd 10, 11:03 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 126
Default 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   Report Post  
Old January 5th 10, 07:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,670
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show chart only? Eric Excel Discussion (Misc queries) 4 December 22nd 09 04:29 PM
Show Zeros in some cells even though worksheet set to not show zer SteveM Excel Discussion (Misc queries) 6 August 18th 09 03:14 PM
how do i sort a worksheet data to show repetitve data and show mrcheatherington Excel Worksheet Functions 1 December 30th 07 02:26 PM
do not show zeros in pivot chart (pie chart) klp Charts and Charting in Excel 2 September 5th 07 02:12 PM
How can I show data under a Chart that I inserted in a worksheet? Kimo Charts and Charting in Excel 1 February 21st 05 04:11 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017