I dont undestand the why the behaviour of number format on y axis for a diagram is different in Excel 2016 compared with Excel 2010.
For example if I call the Number format property as mentioned bellow, I'm getting diffrent result on Excel 2016 compared with Excel 2010.
? myDiag.Diagramms.Item(1).Chart.Axes(xlCategory).TickLabels.NumberFormat
' Result in Excel 2010: 0.00
? myDiag.Diagramms.Item(1).Chart.Axes(xlCategory).TickLabels.NumberFormat
' Result in Excel 2016: #.000
On an diagram from Excel 2010 the y axes value are displayed :
2; 1.5; 1.00;...; -1.00; -1.5; -2
instead in Excel 2016 the values are displayed strangely:
002; 002; 001; ...; -001; -002; -002
I have tryed clearing number formatting, I have tried setting diffrent formats in Excel 2016 without any result. Only number formats like -002 or other strange formatting are being displayed.
Regards,