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/
