Excel 2007 VBA Problem setting Axis Title

Question

I need help setting the X and Y axes title inside Excel 2007 VBA. It keeps complaining about "Object required":

Sub macro2()

Dim xAxis As Axis

icount = 1

Charts.Add
Charts(icount).Name = iskewplane & "deg Skew Plane"
Charts(icount).Activate

Set xAxis = Charts(icount).Axes(xlCategory)
With xAxis
    .Axis
    .AxisTitle.Text = "Theta (deg)"
End With

Is there something wrong in my code? I tried recording the macro during setting the axis title name, but the macro is blank during the name setting.

Any help is appreciated

JMax · Accepted Answer · 2011-08-12 14:33:03Z

6

You should use Option Explicit because iCount wasn't defined and iskewplane wasn't either.

Here is the right code:

Sub mac()
    Dim xAxis As Axis
    Dim iCount As Integer
    iCount = 1
    Charts.Add
     Charts(iCount).Name = "deg Skew Plane"
    Charts(iCount).Activate

    Set xAxis = Charts(iCount).Axes(xlCategory)
    With xAxis
        .HasTitle = True
        .AxisTitle.Caption = "Theta (deg)"
    End With
End Sub

answered Aug 12, 2011 at 14:33

JMax

26.7k12 gold badges74 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dominic Over a year ago

.HasTitle = True That was what I was missing, thanks! I have the .HasTitle=True further down in the code, but it needs one before I can set it. Duh.

Shai Alon Over a year ago

I had exactly the same mistake: the .HasTitle was missing! Thanks!

Tom Juergens · Accepted Answer · 2011-08-12 14:35:29Z

3

You first have to create the AxisTitle object - an axis doesn't automatically have one. This is done by setting Axis.HasTitle = True - a slightly unusual method.

answered Aug 12, 2011 at 14:35

Tom Juergens

4,6224 gold badges37 silver badges33 bronze badges

Collectives™ on Stack Overflow

Excel 2007 VBA Problem setting Axis Title

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related