I have a chart with dates along the X axis, but the chart displays them quite close together, producing a rather ugly graph. How might I reduce the number of visible labels to increase the readability a little?
... -> Edit chart -> Customize -> Gridlines -> Horizontal Axis (in drop down) -> Major gridline count
Major gridline count you can select or type however many dates you want to see on the horizontal label here, for
auto mine shows up with a reasonable number of dates but if you wanted to see 20 dates or 10 dates you can type 20 or 10 here respectively.
Note: if you do not see
Horizontal Axis under gridlines you need to go to
Customize -> Vertical axis
Treat labels as text is unchecked.
in your specific example dd-mm-yyyy is not a recognized
2014-04-24 date format so use the following formula to fix that, paste in cell F1 for example :
(make sure to
Format->Number->Date on this entire new column F)
Bonus: Depending on how you want to present the data you can also create a fake label column to display important dates you want in various ways.
For example you can put this formula in G1 in conjunction with the note above
which will create a list of dates you can use as a text label to only display important dates, however with the amount of points you have in your data you have to stretch the chart out way larger than the web page to be able to display that information because google sheets is randomly deciding which label to omit because of size constraints.