I want to create (I did it already) chart with my data related on date. But my dates is not sequence, like 01/02/22, 02/02/22, 03/02/22 etc…My date looks like 02/02/22, 10/02/22, 15/02/22, 07/03/22, 12/03/22, 04/04/22, 19/04/22
But when I am creating chart related on these data, my chart are showing and all other missing dates, between 02/02/22 to 19/04/22 , I don’t need it.
So my question, how to get rid of that, I want to that my chart bottom line where is showing my date, shows just actual dates what I entered to my data table.
Double-click chart.
Double-click x-axis.
Tab “Scale”, Type “Text”
One draw-back: You should sort the data on sheet. Text scales appear in order of appearance.
2 Likes