# Excel and charts

**URL:** <https://www.ruby-forum.com/t/excel-and-charts/142362>\
**Category:** Ruby\
**Created:** [July 7, 2008, 10:33am UTC](https://www.ruby-forum.com/t/excel-and-charts/142362 "2008-07-07T10:33:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sirtyman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/6a8cbe/32.png) [@sirtyman](https://www.ruby-forum.com/u/sirtyman)\
**Post date:** [July 7, 2008, 10:33am UTC](https://www.ruby-forum.com/t/excel-and-charts/142362/1 "2008-07-07T10:33:39Z")

</div>

Hi,  
I have no idea how to (in Excel using win32ole):  
change series mode (in columns or rows)  
add names to axis  
add data X’es data

Thanks in advance

---

<div class="post-metadata">

**Author:** ![sirtyman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/6a8cbe/32.png) [@sirtyman](https://www.ruby-forum.com/u/sirtyman)\
**Post date:** [July 7, 2008, 11:54pm UTC](https://www.ruby-forum.com/t/excel-and-charts/142362/2 "2008-07-07T23:54:45Z")

</div>

Marcin T. wrote:

> Hi,  
> I have no idea how to (in Excel using win32ole):  
> change series mode (in columns or rows)  
> add names to axis  
> add data X’es data
> 
> Thanks in advance

Perhaps these articles will help:

> **[Automating Excel: Creating Charts](http://rubyonwindows.blogspot.com/2008/06/automating-excel-creating-charts.html)**
>
> They say a picture is worth a thousand words, and sometimes a chart can make your point more effectively than the raw data behind it can. Th...

> **[Automating Excel: Chart, Axis, and Legend Titles](http://rubyonwindows.blogspot.com/2008/06/automating-excel-chart-axis-and-legend.html)**
>
> A reader writes, "I need to use Ruby to automate Excel... How can I set the chart title, axes title, or legend name, etc in the chart by usi...

David

> **[Ruby on Windows](http://rubyonwindows.blogspot.com)**
>
> On using the Ruby programming language on the Microsoft Windows platform