Data label on chart not displaying what I expect?

No Andy it is not. The problem here is that I display data based on an option button selection and the data label is displayed as 5,678 but I want 5 678. The data that feeds the chart is formatted with a space. When I navigate to this sheet, I only get the correct data label after clicking a different option button to the one that is currently selected? I don't think it has anything to do with code though?
Thanks in advance

I have solved the problem by replacing "Linked to Source" with a custom format. Thanks to all for your interest.