# Excel Chart

**URL:** <https://www.ruby-forum.com/t/excel-chart/76161>\
**Category:** Rails\
**Created:** [November 16, 2006, 10:35am UTC](https://www.ruby-forum.com/t/excel-chart/76161 "2006-11-16T10:35:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pascalschudel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/5f8ce5/32.png) [@pascalschudel](https://www.ruby-forum.com/u/pascalschudel)\
**Post date:** [November 16, 2006, 10:35am UTC](https://www.ruby-forum.com/t/excel-chart/76161/1 "2006-11-16T10:35:13Z")

</div>

Hey at all

I’ve a question about excel chart:  
i want to export some data into excel and generate a chart with  
different styles.  
unfortunately, the generated chart is in fullscreeen-mode. how can i set  
the size by generating the chart?

does anybody know a page where i can find some information about excel  
charts?

thanks a lot!  
Pascal

---

<div class="post-metadata">

**Author:** ![pascalschudel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/5f8ce5/32.png) [@pascalschudel](https://www.ruby-forum.com/u/pascalschudel)\
**Post date:** [November 16, 2006, 3:28pm UTC](https://www.ruby-forum.com/t/excel-chart/76161/2 "2006-11-16T15:28:57Z")

</div>

Programming Ruby 2nd edition page 270.

Pascal Schduel wrote:

> Hey at all
> 
> I’ve a question about excel chart:  
> i want to export some data into excel and generate a chart with  
> different styles.  
> unfortunately, the generated chart is in fullscreeen-mode. how can i set  
> the size by generating the chart?
> 
> does anybody know a page where i can find some information about excel  
> charts?
> 
> thanks a lot!  
> Pascal

---

<div class="post-metadata">

**Author:** ![pascalschudel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/5f8ce5/32.png) [@pascalschudel](https://www.ruby-forum.com/u/pascalschudel)\
**Post date:** [November 16, 2006, 3:42pm UTC](https://www.ruby-forum.com/t/excel-chart/76161/3 "2006-11-16T15:42:09Z")

</div>

sorry, it didn’t help, do you know some other examples?  
creating the excel-sheet works, but the chart always is in  
fullscreen-mode, but it has to be in a smaller size.

Guest wrote:

> Programming Ruby 2nd edition page 270.
> 
> Pascal Schduel wrote:
> 
> > Hey at all
> > 
> > I’ve a question about excel chart:  
> > i want to export some data into excel and generate a chart with  
> > different styles.  
> > unfortunately, the generated chart is in fullscreeen-mode. how can i set  
> > the size by generating the chart?
> > 
> > does anybody know a page where i can find some information about excel  
> > charts?
> > 
> > thanks a lot!  
> > Pascal

---

<div class="post-metadata">

**Author:** ![pascalschudel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/5f8ce5/32.png) [@pascalschudel](https://www.ruby-forum.com/u/pascalschudel)\
**Post date:** [November 17, 2006, 3:18am UTC](https://www.ruby-forum.com/t/excel-chart/76161/4 "2006-11-17T03:18:51Z")

</div>

Google for Excel, COM, macro, …

You shouldn’t have any trouble finding sample code (probably in VB or  
VBA) to do what you want.

Alternately, any good book on advanced Excel or MS Office programming  
should have the info you’re looking for.

Regards

Dave M.

---

<div class="post-metadata">

**Author:** ![pascalschudel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/5f8ce5/32.png) [@pascalschudel](https://www.ruby-forum.com/u/pascalschudel)\
**Post date:** [November 17, 2006, 2:34pm UTC](https://www.ruby-forum.com/t/excel-chart/76161/5 "2006-11-17T14:34:06Z")

</div>

You can also try recording a macro of the steps you take to manually  
produce the chart.

Record a macro making the chart full screen. Record a macro of it not  
full screen. What’s different in the two? Apply that to your Ruby code.