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.

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.