We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Unable to plot multiple Y -axes on excel

Thread ID:

Created:

Updated:

Platform:

Replies:

117573 Nov 11,2014 05:05 AM UTC Nov 17,2014 01:37 PM UTC WPF 3
loading
Tags: XlsIO
Mahesh
Asked On November 11, 2014 05:05 AM UTC

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 [Syncfusion]
Replied On November 11, 2014 10:29 AM UTC

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
Replied On November 12, 2014 04:42 AM UTC

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 [Syncfusion]
Replied On November 17, 2014 01:37 PM UTC

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.


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;