Would need more detail but it sounds like you have a Line chart with Chart
Option | Axis setting as Automatic or Time Scale
In this case Day is the smallest unit
Use Chart Option | Axis and set to Category
But be aware that now the x-axis spacing will not be scaled
However, an XY chart will work as you need -- if I read your message
correctly
best wishes