I use the Dutch version of Excel 2011 for Mac and have a problem with the decimal separator. I changed the decimal separator in my system settings a while ago, so that commas are the decimal separator and dots are the thousand separator. This works perfectly fine when I type data and make calculations in excel. However, when I create charts from the data in my excel sheet, the numbers on the axis use dots to separate decimals instead of commas. What is going wrong?
And how can I make the charts' axis use the same decimal separator as the data in my sheet?
Help is very much appreciated.