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

[Administrator]

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

[Chella Pandian B]

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.

[Administrator]

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.

[Chella Pandian B]

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.

[Chella Pandian B]

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.