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

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!

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

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
_______


"dbsavoy" wrote in message
...
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!

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

Jon, you've been a great help. Thanks much!!!!
:)


"Jon Peltier" wrote:

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
_______


"dbsavoy" wrote in message
...
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!