Coding "Category (X) Axis"...

[Guest]

I'm running Access-to-Excel automation, and using Auto_Open in Excel to see
things like..
ActiveChart.ChartTitle.Text = " The Week" & TheWk

Works fine. I want to "fill a label on the Chart" with a concatenation.

Can I...
ActiveChart."xxx???".Text = "ABC " & TheDay..as an Example.

What would be the ""xxx???" for a "label" such as the "Category (x) Axis"

TIA - Bob

 

[Andy Pope]

Hi,

Macro recorder gave the majority of the code.

With ActiveChart
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _
Format$(Now(), "dddd") & "'s X axis label"
End With

Cheers
Andy

 

[Guest]

Beautiful.

Thank you Andy,
Bob

Hi,

Macro recorder gave the majority of the code.

With ActiveChart
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _
Format$(Now(), "dddd") & "'s X axis label"
End With

Cheers
Andy