Set Series Axis Interval Unit for a Chart in Excel

[Vinod K Bobba]

We are generating an embedded chart in excel.

Is there any way to specify interval unit in Axis options.?

Please let us know ASAP. Appreciate your feedback.

[Geetha M]

Hi Vinod,

Thank you for your interest in Syncfusion products.

You may set interval unit using IChartCategoryAxis.TickLabelSpacing property. Here is the code snippet:

chart.PrimaryCategoryAxis.TickLabelSpacing = 3;

With the above code, primary category axis is displayed with interval unit set to 3.

Please try this and let me know if you have any questions.

Regards,
Geetha

[Vinod K Bobba]

Hi Geetha,

Thank you for your suggestion.

I am generating a 3D chart in my excel.

This code doesn't work for that.

I am also trying to set the interval for Series axis. Even that doesn't work.

Is it any thing to with the type of chart the code is supposed to work?

Please let us know ASAP.

Appreciate your feedback.

[Geetha M]

Hi Vinod,

Thank you for the details.

I am afraid that I am not able to reproduce the problem with 3D charts.

To adjust the interval between series, you need to set the GapWidth of Series.

chart.Series[0].SerieFormat.CommonSerieOptions.GapWidth = 250;

Could you please modify the sample placed in the link below and send to me so that I could recreate and find the cause of the problem?
http://help.syncfusion.com/samples/XlsIO.Windows/F92868/F92868.zip

Regards,
Geetha

[Vinod K Bobba]

Hi Geetha,

Thank you for your feedback.

I am attaching a sample which shows the problem I am trying to figure out.

I am generating Column_3D chart with multiple series and I want to embed the chart along with the data, So I am using IChartShape.

The issue is, when I generate the chart I am not able to see all the series names on my Series Axis.

The Interval Unit value on Series Axis is set to 24 in excel. It has to be set to 1 to see all the names. But I am not able to do that.

I also tried with IChart Object instead of IChartShape, this works fine. But I cannot embed the chart on the same page.

Please let us know ASAP. I am spending lot of time figuring this out.

Appreciate your Feedback. Thank you.



TestChart_ee0a04f0.zip

[Geetha M]

Hi Vinod,

Thank you for the details.

I was able to see the problem. Could you please create an incident in Direct trac mentioning the forum id and subject so that we could send you further details regarding the problem?

Regards,
Geetha

[ISIZ BV]

I've asked this very same question through directtrac and got almost the same answer, but it really doesn't work at all.

I think this really is a big issue.
I'm surprised few people posted this.

[Geetha M]

Hi Robert,

We regret for the inconvenience caused.

Could you please create a direct trac incident for the same so that we could you further details on it? Also, please let us know the direct trac incident you are referring to so that we can update the details.

Regards,
Geetha

[ISIZ BV]

I was able to set the value to 2 or higher and that worked but PrimaryCategoryAxis.TickLabelSpacing = 1 is ignored.

Do I need to use the new version. It's an older application and it takes too much time to change it, I think.

[Geetha M]

Hi Robert,

Thank you for the details.

Value "1" for TickLabelSpacing is default and it plots all the labels without omission. I am not able to reproduce any problem here. Could you please modify the sample in the link below and send back to me?

http://help.syncfusion.com/samples/XlsIO.Windows/F92868/F92868.zip

Regards,
Geetha