# Excel sheet charts

**URL:** <https://www.ruby-forum.com/t/excel-sheet-charts/176376>\
**Category:** Ruby\
**Created:** [September 29, 2009, 8:05pm UTC](https://www.ruby-forum.com/t/excel-sheet-charts/176376 "2009-09-29T20:05:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sss](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/57b2e6/32.png) [@sss](https://www.ruby-forum.com/u/sss)\
**Post date:** [September 29, 2009, 8:05pm UTC](https://www.ruby-forum.com/t/excel-sheet-charts/176376/1 "2009-09-29T20:05:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sss](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/57b2e6/32.png) [@sss](https://www.ruby-forum.com/u/sss)\
**Post date:** [September 29, 2009, 11:54pm UTC](https://www.ruby-forum.com/t/excel-sheet-charts/176376/2 "2009-09-29T23:54:45Z")

</div>

Swarup Swarup wrote:

> 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

Hi Swar,  
Could you maybe flesh out your question a little bit? It’s not entirely  
clear what you are asking, at least to me.