Solved: Change overall chart font

[thitetaf]

Hello,

Am struggling to find a way to do a VBA code that would change the fontsize of a given graph. The idea would be to change the overall graph font size without having to go through changing it items by items.

In Excel, when you click on the chart object, you can indeed change the overall font size but can't figure out how to do it in a VBA code.

Hope having been clear,
Thanks,
Thibault

[Aflatoon]

You can set the Font for the chartarea:
ActiveSheet.Shapes("Chart 1").Chart.ChartArea.Font.Size = 16

for example. This is equivalent to what you do in the UI.

[thitetaf]

thanks