Hi,

I'm trying to add a second value axis to a clustered column chart (co.Chart). But when I try to refer to the secondary axis I get an error.

... stuff omitted ...

With co.Chart
    .SetSourceData Source:=chartRng, PlotBy:=xlColumns
    .ChartType = xlColumnClustered
    .HasTitle = True
    .HasAxis(xlCategory, xlPrimary) = True
    .HasAxis(xlCategory, xlSecondary) = False
    .HasAxis(xlValue, xlPrimary) = True
    .HasAxis(xlValue, xlSecondary) = True
End With

With co.Chart.Axes(xlValue, xlSecondary)
    .HasTitle = True
    With .AxisTitle
        .Caption = "Denials"
        .Font.Size = 6
        .Orientation = xlUpward
    End With
End With

Can anyone straighten me out?

Thank you,

Robert Stober