Freeze Graph size when hidding rows.

  • Thread starter Thread starter SpeeD72
  • Start date Start date
S

SpeeD72

Hi guys..

I have a tabel with aprox 50 rows, and i have to hide
some of them (when valeu = 0). When i do this the graph
that i have in "front" of this rows shrinks!!!

How can i freeze the Graph??? Can i give "give" a fixed
size to the graph, via macro, after o hide those rows???

I hope i made my self clear... :-)

Thanks a lot!

SpeeD72
 
Bill -

Don't forget, you have to Shift-Click on the chart first, to select the
chart object. It's the chart object that has the Properties tab in its
Format dialog.

- Jon
 
Jon,

That's what I remembered, too, but I tested before I posted. What I said
was true for both Excel 2000 and 2002.

--Bill
 
Bill -

(Sorry for the delay)

Having used Excel 97 exclusively until very recently, I'd never seen
that Properties tab in the Format Chart Area dialog. Thanks for
teaching an old dog a new trick.

- Jon
 
Back
Top