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