Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2006

Tip: Looking for answers? Try searching our database.

How can I hide a range of columns without hiding charts there?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dbsavoy - 29 Aug 2006 22:01 GMT
I've got a spreadsheet with about 60 columns and I need to hide the first
thirty or so.  Each month, I'll need to hide one or two more from the left
while one or two more are created off to the right.  It's an ongoing range of
dates, if that makes more sense.

Anyway, I've got two charts located on that page and feel that there must be
a way of formatting them so that the charts are still visible when I hide
columns.  The simple way to do this would be to move the charts out of the
range of columns to be hidden.  But I'd rather not have to reposition the
charts everytime I hide an additional column or two.

This one has me perplexed.  Any help would be much appreciated.  Thanks!
Jon Peltier - 30 Aug 2006 04:28 GMT
Hold shift and select one or more charts. Press CTRL+1 to bring up the
Format Shape dialog. On the Properties tab, change the selected option to
Don't move or size with cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> I've got a spreadsheet with about 60 columns and I need to hide the first
> thirty or so.  Each month, I'll need to hide one or two more from the left
[quoted text clipped - 10 lines]
>
> This one has me perplexed.  Any help would be much appreciated.  Thanks!
dbsavoy - 31 Aug 2006 16:30 GMT
Jon, you've been a great help.  Thanks much!!!!
:)

> Hold shift and select one or more charts. Press CTRL+1 to bring up the
> Format Shape dialog. On the Properties tab, change the selected option to
[quoted text clipped - 21 lines]
> >
> > This one has me perplexed.  Any help would be much appreciated.  Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.