Hi,
I am creating a chart in Excel.
At lines 15-17 (see below) I get
"Method 'Axes' of Object 'Chart_Chart' failed."
Any help in getting this chart to create would be greatly appreciated.
Thanks,
Jimmy


2 Charts.Add
3 ActiveChart.ApplyCustomType ChartType:=xlBuiltIn,
TypeName:= _
4 "Lines on 2 Axes"
5 ActiveChart.SetSourceData
Source:=Sheets("Chart").Range(topLeft &
":" & bottomRight), PlotBy:= _
6 xlRows
7 ActiveChart.Location Whe=xlLocationAsObject,
Name:="Chart"
8 With ActiveChart
9 .HasTitle = True
10 .ChartTitle.Characters.Text = "Bid/Quote Success Rate"
11 .Axes(xlCategory, xlPrimary).HasTitle = False
12 .Axes(xlValue, xlPrimary).HasTitle = True
13 .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = _

14 "# of Bids/Quotes Received"
15 ' .Axes(xlCategory, xlSecondary).HasTitle = False
16 ' .Axes(xlValue, xlSecondary).HasTitle = True
17 ' .Axes(xlValue, xlSecondary).AxisTitle.Characters.Text
= _
18 "% Submitted of Received or % Won to Date of
Submitted/Received"
19 End With