View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.