Setting the distance between vertical gridlines

[ltilquin]

Hi,

I have a chart with more than 400 datapoints.
The PrimaryValueAxis (Y-axis) represents values, The PrimaryCategoryAxis (X-axis) represents dates.
I want to see all the datapoints on the graph but only a few data labels.

By using TickLabelSpacing I can set how many labels I want to see on the X-axis (i.e. 5)

But the vertical gridline interval stays at 1. I want to have as much vertical gridlines as I have labels on the X-axis.

See the enclosed pictures.

In PowerPoint you can set the interval between the vertical gridlines but I don't find the property in the Spire.Presentation library.


PS: I also want to format the X-axis labels as a date without time.
I tried

Code: Select all

chart.PrimaryCategoryAxis.NumberFormat = "dd/MM/yyyy";

but it doesn't work.

Thanks for your help.

Kind regards,
Laurent

[Brian.Li]

Hello Laurent,

Thanks for your inquiry.
I am sorry that our Spire.Presentation does not yet support setting the interval of tick marks. But I have added it as a new feature into our upgrade list with the ticket SPIREPPT-1611. Once it is achieved, we will let you know. Apologize for the inconvenience caused.

Besides, you can refer to the following code to format the X-axis labels as a date without time. If this doesn't work for you, please provide your test PPT file for further investigation. You could upload it here or send it to us (support@e-iceblue.com) via email. Thanks in advance

Code: Select all

            chart.PrimaryCategoryAxis.NumberFormat = "dd/mm/yyyy";

Sincerely,
Brian
E-iceblue support team

[ltilquin]

Hi Brian,

Thanks for your reply.
Have you any idea how long it will take to release the update?

Kind regards,
Laurent

[Brian.Li]

Hello Laurent,

Thanks for your follow up.
Regarding the new feature SPIREPPT-1611, I have confirmed with our Dev team, if all goes well, we expect to provide you a new version within two weeks.

Sincerely,
Brian
E-iceblue support team

[ltilquin]

Hello Brian,

That's good news!
Thanks again for your feedback.

Kind regards,
Laurent

[Brian.Li]

Hello Laurent,

Hope you are doing well.
Glad to inform you that we just released Spire.Presentation Pack Hotfix Version:6.7.2, it adds a new feature to support setting the interval of tick marks (As shown in the following code), please download it from the following links to test on your side. Looking forward to your test result.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.Presentation/6.7.2

Code: Select all

Presentation ppt = new Presentation();
ppt.LoadFromFile(intputFile);
IChart chart = ppt.Slides[0].Shapes[0] as IChart;
IChartAxis chartAxis = chart.PrimaryCategoryAxis;

chartAxis.TickMarkSpacing = 30;
ppt.SaveToFile(outputFile, FileFormat.Pptx2013);

Sincerely,
Brian
E-iceblue support team

[ltilquin]

Hi Brian,

Thanks a lot for your support.
I will test this in the coming weeks and give you feedback asap.

Grts,
Laurent

[Brian.Li]

Okay, thanks for your quick response.
If you encounter any problems during testing, just feel free to contact us.

Sincerely,
Brian
E-iceblue support team

[ltilquin]

Hi Brian,

It works as expected.
Thanks a lot for your support.

Grts,
Laurent

[Brian.Li]

You are welcome.
If you encounter any issues related to our products in the future, please feel free to contact us.

Sincerely,
Brian
E-iceblue support team