Chart data table does not display the numbers as in the source

Question

Dear MS Community,

I have an issue with the one chart created. The data table of the chart is not displayed the same formatting as in the source file. The source file data numbers are converted to millions whereas the data table of the chart displays it in thousands.

Data table of the chart:

vs in the source:

I went through the followings:

• set up in the chart
• played around with the number formatting in the source file (in thousands, in absolute value etc.)
• checked my laptop set up - number formatting, langugae, thousand and decimal separator etc.

On other laptops with same settings it works.

Could you please help me, maybe you have some more useful tips that I can try out?

Thank you!

Answer 1

We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.