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"?

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"?

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"?

Not really. If you need help with modifying the macros I will be glad to
help. The chart macros are a little tricky to modify.

"rohan" wrote:

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"?

Ok, the first one is about the title/label:

With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "EAGLE Servers CPU Utilization 11/02/07"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _
"15 Minutes Interval"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "%Utilized
(Busy)"
End With

I can set the Titlt as:
objChart.HasTitle = True
objChart.ChartTitle.Characters.Text = "EAGLE Servers CPU Utilization 11/02/07"

How about the X-axes (xlCategory) and Y-axes (xlValue) label?

Thanks much!

"Joel" wrote:

Not really. If you need help with modifying the macros I will be glad to
help. The chart macros are a little tricky to modify.

"rohan" wrote:

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"?

I got this from a recorded macro

ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(1).Select
ActiveChart.PlotArea.Select
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = 3
.MaximumScaleIsAuto = True
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With

"rohan" wrote:

Ok, the first one is about the title/label:

With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "EAGLE Servers CPU Utilization 11/02/07"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _
"15 Minutes Interval"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "%Utilized
(Busy)"
End With

I can set the Titlt as:
objChart.HasTitle = True
objChart.ChartTitle.Characters.Text = "EAGLE Servers CPU Utilization 11/02/07"

How about the X-axes (xlCategory) and Y-axes (xlValue) label?

Thanks much!

"Joel" wrote:

Not really. If you need help with modifying the macros I will be glad to
help. The chart macros are a little tricky to modify.

"rohan" wrote:

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"?