(Solved) – Application.ThousandsSeparator only affects cells, chart labels, axis not working

  • by
(solved)-–-application.thousandsseparator-only-affects-cells,-chart-labels,-axis-not-working

I need some report where our clients can choose what thousand seperator they would like.

using below code this is working just fine for the cells. But the chart attached to it doesn’t follow the same thousand seperator. Only when I save the file, close it and reopen it, the seperator is displayed correctly.

Sub changeSeperators()
    Application.ThousandsSeparator = " "
    Application.UseSystemSeparators = False
End Sub

I tried different Application. calculations, but none seem to work.
Also a refresh of the charts doesn’t want to work.

If I don’t do it within vba but just in the options of excel to change the seperator it is just working as supposed and updates both the cells as the chart labels, axes correctly

Any advice on how to tackle this?

Thanks,

Leave a Reply

Your email address will not be published. Required fields are marked *