Chart Axis Text 2

[JohnCR]

I'm trying to label a chart axis with this ...

Set objAxis = xlapp.ActiveChart.Axes(xlValue, xlPrimary)
With objAxis
.HasTitle = True
.Title.Text = "Issues"
End With


And I keep getting a Unable to get the Axis property of the Chart class, Code 800A03EC.

Does anyone haev any idea what I'm missing here?

TIA,

JohnCR

 

[SkipVought]

Set a reference to the Excel Object Library. Maybe the xlCONSTANTS have not been exposed otherwise.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[PHV]

xlCategory=1
xlColumns=2

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JohnCR]

BINGO!

That did it. (sunofa.....)

Thanks for all the assistance.