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

Set Series Axis Interval Unit for a Chart in Excel

Thread ID:

Created:

Updated:

Platform:

Replies:

92868 Feb 9,2010 02:30 PM UTC Jun 8,2010 11:40 AM UTC ASP.NET Web Forms (Classic) 9
loading
Tags: XlsIO
Vinod K Bobba
Asked On February 9, 2010 02:30 PM UTC

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 [Syncfusion]
Replied On February 10, 2010 04:23 AM UTC

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
Replied On February 15, 2010 04:53 PM UTC

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 [Syncfusion]
Replied On February 16, 2010 05:15 AM UTC

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
Replied On February 18, 2010 02:50 PM UTC

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 [Syncfusion]
Replied On February 19, 2010 06:39 AM UTC

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
Replied On February 19, 2010 04:04 PM UTC

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 [Syncfusion]
Replied On February 23, 2010 04:08 AM UTC

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
Replied On June 8, 2010 08:04 AM UTC

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 [Syncfusion]
Replied On June 8, 2010 11:40 AM UTC

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

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

;