Unable to plot multiple Y -axes on excel

[Mahesh]

I am using XLSIO excel and I have requirement to plot a chat on excel with multiple Y - axes.

I am not able to figure out how to achieve this.

Help pls

[Prakash Kumar D]

Hi Prince,

 

Thank you for using Syncfusion Products.

 

Please refer the below code snippets to achieve your requirement. We have also shared a sample for your reference. Kindly refer to this and let us know if your requirement is achieved.

 

Code snippet:

 

if (chart.SecondaryValueAxis != null)

     chart.SecondaryValueAxis.Title = "Secondary Value Axis";

 

//Here is the code to display secondary axis.

  chart.SecondaryValueAxis.IsMaxCross = true;

  chart.SecondaryCategoryAxis.IsMaxCross = true;

 

Sample Link: Sample.zip

 

Please let us know if you need any clarification.

 

Regards,

Prakash Kumar

 

[Mahesh]

This may work fine only for two Y axes. But in my requirement I have to plot a chart with  more than two Y axes. It depends on the number of values I get from some Web service.

How to acheive this?

Thanks for help in advance

[Prakash Kumar D]

Hi Mahesh,

 

Thank you for updating us.

 

By default, MS Excel supports plotting primary and secondary axis alone and XlsIO does the same. There is no support to include more than 2 axes from XlsIO.

 

Please let us know if you have any concerns.

 

Regards,

Prakash Kumar.