Coding "Category (X) Axis"...

[Bob Barnes]

I'm running Access-to-Excel automation, and using Autpen 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

 

[Bob Barnes]

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