I have a chart associated with a Calc spreadsheet. The chart has dates on the x-axis and values on the y-axis.
In Format y-axis you can edit the Interval between values (and edit the Minimum and Maximum values).
In Format x-axis there is no such option.
Because the chart covers a long period of time (nearly 3 years) the x-axis displays too many dates.
I want increase the interval between dates and reduce the number of Major Grid lines.
How do I achieve this?
Double click on the x-axis of @Villeroy’s example. You can set the intervals, neatly by Day, Month, or Year toward the bottom of the dialog box. If your dates are not actual Calc dates but text, you might look into adding another row/column that converts to Calc dates and use that for your x-axis rather than just text. Generally converting from text to date is done with the DATEVALUE() function, but it can get tricky depending on the text date format, your locale, etc.