If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Freeze Graph size when hidding rows.
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 ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Bill Koran wrote: 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 "Jon Peltier" wrote in message ... 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 Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Bill Koran wrote: Right-click on the ChartArea (just inside the chart border), and select "Format Chart Area". On the "Properties" tab, change the selection under Object Positioning to get the behavior you want. --Bill "SpeeD72" wrote in message .. . 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 |
Thread Tools | |
Display Modes | |
|
|