Label x Axis and y Axis with VBA

[dhartford]

I'm creating the Scatter Plot chart (excel) from Access VBA. Does anyone know what property of the chart is to label the X and Y axis?

Thank you very much in advance.

[Dave]

Not sure about Access VBA but this does it for XL VBA. HTH. Dave

With ActiveChart
   'chart name
   .HasTitle = True
   .ChartTitle.Characters.Text = "Chart Name"
   'X axis name
   .Axes(xlCategory, xlPrimary).HasTitle = True
   .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "X-Axis"
   'y-axis name
   .Axes(xlValue, xlPrimary).HasTitle = True
   .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Y-Axis"
End With