|Do you know where your variables are?|
Re^2: Win32::OLE::Const 'Microsoft Excel'by rupesh (Hermit)
|on Dec 06, 2004 at 10:51 UTC||Need Help??|
Thanks for your post. Although I'm now able to format the color-context of the Chart, I'm facing a new problem now.
I have a worksheet that has data dynamically entered to it, in the form of tables (2 columns and 'n' rows). 25 - 35 such tables are possible in a single sheet.
A part of my code:
How do I draw separate charts for each table? I tried various loops, but I get charts which are totally irrelevant to the data.