From: Swarup Swarup Date: 2009-09-30T03:05:20+09:00 Subject: excel sheet charts Hello, I have to plot charts in excel sheet. I don't know where the data is stored so row information and how much is the data info is not known in advance. Rows and Cols get computed based on the length of the data records, which can vary every time. I tried following but it didn't work: Suppose VariableX = 1 VariableY = 10 excelBrowser.Range("A#{VariableX}:B#{VariableY}").Select() Any suggestions. Thanks, Swar -- Posted via http://www.ruby-forum.com/.