VBA Chart Axis Formatting

Hello everyone!

I am trying to make use of Jon Peltier's "Chart Creation" code:
https://peltiertech.com/Excel/Charts...tCreation.html

I copied the CreateChart procedure into my "Sheet1" and I was able to set the different ranges.
So far everything works, thank you, Jon!

Unfortunately, I can't work out, how to format the Axis.
Two things I'm trying to change:
1. Font
2. Show the vertical Axis without values and set a maximum value.

This is Jon's code :

Please Login or Register  to view this content.

And this is the Macro I recorded:

Please Login or Register  to view this content.

The Macro causes an "Automation Error".

Many thanks in advance for any help!

Toni

For category labels use

Please Login or Register  to view this content.

for vertical scale use

Please Login or Register  to view this content.