PrimaryValueAxisTitle error

[ScottyWm]

I'm at a loss... I used the VBA macro recorder to make a chart from a pivot table. Everything works fine except for one thing. I can not get a Title on the Primary Axis. The secondary axis, primary category, and Chart title all appear the way they should, but the PrimaryValueAxisTitle does not appear when I run the macro. Here's my code:

ActiveChart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
ActiveChart.SetElement (msoElementPrimaryValueAxisTitleAdjacentToAxis)
ActiveChart.SetElement (msoElementSecondaryValueAxisTitleAdjacentToAxis)
ActiveChart.SetElement (msoElementChartTitleAboveChart)

Why doesn't it show up? I don't get an error when it executes that line. But I get an error when the code tries to add text to the element (because it isn't there).

Any help?

 

[RoryA]

It's a bug in the OM - see here: http://excelmatters.com/2018/04/25/...soelementprimaryvalueaxistitleadjacenttoaxis/

 

[ScottyWm]

It's a bug in the OM - see here: http://excelmatters.com/2018/04/25/...soelementprimaryvalueaxistitleadjacenttoaxis/

Thank you thank you thank you!! Wish I'd come here before spending hours trying to work around the problem. Seems like Microsoft would have fixed this with all the updates they push out.

 

[Agent1]

It's now 2021 and bug is still not fixed, but here is a workaround:

With ActiveChart
    .SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
    .SetElement (msoElementPrimaryValueAxisTitleAdjacentToAxis)
    .SetElement (msoElementSecondaryValueAxisTitleAdjacentToAxis)
    .Axes(xlValue).HasTitle = True
    .Axes(xlSecondary).HasTitle = True
    .Axes(xlCategory).HasTitle = True
End With