Hello!
I recently upgraded my MS Office from 2010 to 2016 and found out that some of my charts are now showing wrong values in their data tables.
I googled this problem and found this thread from 2016: https://answers.microsoft.com/en-us...-formats/189bf107-546e-44c6-9572-ad5248b68a02
but it has no solution
My source data is formatted to show numbers in thousands (non-standard formatting # ###,0 )
It works fine as a table and shows up OK on a chart, but data table still shows raw data in standard format (that is 112,3 thousands is 112300 in data table under the chart).
Did anyone find any solution? Did any further version of Excel solve this?
Currently I'm wasting my time on adding extra rows of source data with formula number/1000 to have the same format both on chart and in the data table
I recently upgraded my MS Office from 2010 to 2016 and found out that some of my charts are now showing wrong values in their data tables.
I googled this problem and found this thread from 2016: https://answers.microsoft.com/en-us...-formats/189bf107-546e-44c6-9572-ad5248b68a02
but it has no solution
My source data is formatted to show numbers in thousands (non-standard formatting # ###,0 )
It works fine as a table and shows up OK on a chart, but data table still shows raw data in standard format (that is 112,3 thousands is 112300 in data table under the chart).
Did anyone find any solution? Did any further version of Excel solve this?
Currently I'm wasting my time on adding extra rows of source data with formula number/1000 to have the same format both on chart and in the data table
