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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top