1. Home
  2. Forum
  3. ASP.NET Web Forms (Classic)
  4. Charts with multiple Y Axis using XLS IO component in asp.net application

Charts with multiple Y Axis using XLS IO component in asp.net application

Hi, I am using the XlsIO component in a web app and need to produce a chart with 2 Y Axis. I cannot, however, find an example of how to do this anywhere in the documentation provided with your product. Please could you advise me on where I can find such an example.

Regards,

Rob O

4 Replies
CP Chella Pandian B Syncfusion Team December 2, 2006 12:20 AM UTC

Hi Rob O

Sorry for the inconvenience. I will get back to you with in 2 day with the updates. Since I have to discuss this issue with my team.

With regards,
Chella.

AD Administrator Syncfusion Team December 3, 2006 06:45 PM UTC

Hi Chella, any help you can offer is most appreciated.

Kind Regards,

Rob O

>Hi Rob O

Sorry for the inconvenience. I will get back to you with in 2 day with the updates. Since I have to discuss this issue with my team.

With regards,
Chella.

CP Chella Pandian B Syncfusion Team December 4, 2006 10:15 PM UTC

Hi Rob O

I tried reproducing a multiple Y-axis chart using MS-Excel but I was unable to find an option for that in MS-Excel. XlsIO only supports features that exist in MS-Excel. So I afraid that XlsIO do not support Multiple Y-axis but this feature is available in our Essential chart where you can create a Multiple Y-axis and import that chart as an image to an Excel sheet.

As far as I investigated I was unable to find multiple Y-axis options in MS-Excel if you have come across it in MS-Excel let us knows so that I can put a feature request for it. We are extremely sorry for the inconvenience. Let me know if you have any other difficulties.

With regards,
Chella.

CP Chella Pandian B Syncfusion Team December 7, 2006 03:11 PM UTC

Hi Rob O,

I seriously apologies for the wrong information about the chart with 2 Y Axis. It is possible to have 2 y-axis in an excel chart. After discussing with my team I have came out with a sample, which demonstrate a chart with 2 y-axis. Please look at sample and let me know if you have any other difficulties. Once again I apologies for the inconvenience.

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:

2-Yaxis.zip

Thanks for your interest in XlsIO.

Best regards,
Chella.

Loader.
Up arrow icon