Excel Chart

Rails
1

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

2

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

3

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

4

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.

5

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.