| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - size change with hide rows
Is there a way to format a chart so that the size of it will not change if
some of the rows on which it sits are hidden? For instance if I have a chart that lays over rows 1 through 25, and I hide rows 5 through 9, the chart height changes. Thanks, Mike. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart - size change with hide rows
I found the answer ... Format chart area .... Select Don't move or size with
cells. "Mike" wrote: Is there a way to format a chart so that the size of it will not change if some of the rows on which it sits are hidden? For instance if I have a chart that lays over rows 1 through 25, and I hide rows 5 through 9, the chart height changes. Thanks, Mike. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the size of a chart title box? | Charts and Charting in Excel | |||
| How do I change the size of the legend key in a chart? | Charts and Charting in Excel | |||
| change chart print size | Charts and Charting in Excel | |||
| Change Chart Size | Charts and Charting in Excel | |||
| Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions | |||
Linear Mode
