I recently came across an interesting bug in the object model for charts, that I have seen mentioned in several forums. The issue is that using
doesn’t actually add a title to the chart axis and therefore any subsequent code that attempts to format the axis bugs out with a 424 error.
As it turns out, the problem is that there are two constants sharing the same value in the OM:
both have the value 306.
The resolution is actually fairly simple – just declare your own constant like this:
Const msoElementPrimaryValueAxisTitleAdjacentToAxis As Long = 307