Thanks Joel. I tried that before and yet was unable to map the macro calls to
VBCrsipt calls. I'll try again.

Is there a reference manual on line for all these Excel/Chart VBScript calls?

Thanks.

"Joel" wrote:

The best way is through a learn macro. Go to tools menu on worksheet and
select Macro - Record New macro. The go to the chart and perrform the
formating maully. Then stop recording and use the recorded macro to make you
own adjustments.

The recorded macro is usually a very specific macro with precise cell
locations. Your job is to make it work in a general purpose macro.

"rohan" wrote:

Through the help of TechNet, I'm now able to create a simple VBScript to
automatically generate an Excel chart. Where can I find the detail
options/methods that I can use to specify more detail information, such as
X-Axes label, similar to objChart.ChartTitle.Characters.Text = "Chart Title"?