Sometimes things that look easy are a bit hard in VB... How can I set the font for CategoryNames?? This is hard for a novice in VB.
My code (I use a radar chart):
Worksheets("Test").ChartObjects(1).Chart.Axes(xlCategory).CategoryNames = Worksheets("Test").Range("A1:A5")
...and then I need to set the font size...