Glad to have been of assistance :-) -- Kais
-----Original Message----- From: Srinadh Karumuri [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 12:57 To: POI Users List Subject: Re: Dynamic number of rows selection for chart in Excel Thanks Kais, The named range with functions in it worked. Alpha =OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1) Numeric =OFFSET(Sheet1!$B$1,1,0,COUNTA(Sheet1!$B:$B)-1,1) Thanks Glen, Hmmm! I do have to get my feet wet. I will try the VB next time. Sri Glen Stampoultzis wrote: > > Perhaps you can use a bit of VB script to update the range. > > Alternatively you can try hook directly into the low level records and > build the support yourself. > > Regards, > > Glen > > At 09:48 AM 27/02/2004, Srinadh Karumuri wrote: > >> I tried 'named range' but it didn't work either. >> If I select a larger range (leaving empty rows in the bottom) for the >> name then the chart is showing the empty area as well. Which is not >> acceptable. >> >> I also observed that named range behaves just like regular range. In >> fact Excel 2000 automatically changes the Name to the range in the >> SourceData...->DataRange. >> >> >> I am attaching a sample excel file. >> >> Thank you in advance, >> Sri >> At 11:42 AM 2/26/2004, you wrote: >> >>> Have you considered using a named range for the chart data source? >>> >>> -- Kais >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] > > > > Glen Stampoultzis > [EMAIL PROTECTED] > http://members.iinet.net.au/~gstamp/glen/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
