Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
Match function...random search? | Excel Worksheet Functions | |||
Hiding multiple columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
print 3 column range in six columns | Excel Discussion (Misc queries) |