Coding "Category (X) Axis"...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Beautiful.

Thank you Andy,
Bob

Andy Pope said:
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
Click to expand...
 
Back
Top