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.

Unable to plot multiple Y -axes on excel

Thread ID:

Created:

Updated:

Platform:

Replies:

117573 Nov 11,2014 12:05 AM Nov 17,2014 08:37 AM WPF 3
loading
Tags: XlsIO
Mahesh
Asked On November 11, 2014 12:05 AM

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 05:29 AM

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 11, 2014 11:42 PM

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 08:37 AM

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.

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.

;