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/
