Reduce X axis label count

[mf0000001]

Hello, I have a chart that has a great deal of data points in the X axis.
The X axis displays date values. The date values are rotated 90 degrees for readability.
However, due to the density of the number of dates displayed, I believe it would improve readability to reduce the number of dates displayed.
I want to leave the data point in place, just suppress the display of the date value in the X axis.
How could I display, say every 5th date in the axis display.

Thank you.

Too many dates

tooManyDates.png (24.88 KiB) Viewed 11 times

Fewer dates

fewerDates.png (15.06 KiB) Viewed 11 times

[amy.zhao]

Hello,

Thank you for your inquiry.

Please try the following settings.

Code: Select all

IChart chart = sheet.Charts[0];
chart.PrimaryCategoryAxis.MajorUnit = 5;

If the above solution does not meet your requirements, please provide your Excel document containing the chart. This will help us investigate the issue and provide you with an effective solution in a timely manner.

Sincerely,
Amy
E-iceblue support team