Strange result in EXCEL

[Peter]

Please take a look at:

http://pasteboard.co/h9uF3IEJO.png


The scale looks like 1001102104..... Is there a way to fix it ?!

[Abirami Varadharajan]

Hi Peter, 

 

Thank you for contacting Syncfusion support. 

 

As per MSExcel behavior, the axis value depends on the major and minor units. So, we request you to set the major unit as mentioned below. 

 

Code Example : 

worksheet.Charts[0].PrimaryValueAxis.MajorUnit = 20.0; 

 

We have prepared the sample for the same which can be downloaded from the following location. 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-22371025.zip  

Please let us know if you need any clarification. 

Regards, 

Abirami.