Axis Title from cell format not working

[gregersdk]

Hello All!

I have made myself a handy little tool for formatting charts and everything works just fine, except formatting the text for chart titles. I have looked at other solutions, and it seems I should have it correct, but still I get Error 424, "Object Required". What gives?

Code underneath, problem line stated in red. The problem seems to be related to using ".Font", but that should be correct.

Please Login or Register  to view this content.

[Andy Pope]

Code works if category axis title is present and variables contain meaningful values.