I am doing an XY scatter graph that shows data for a span of 20 years. However, when the graph is made, the x-axis timeline goes all the way back to 1900. How do you adjust the timeline to only focus on my selected time frame?
The easiest fix might be to try a line chart rather than a scatter chart. Line charts understand dates and times.
If you still want to use a scatter chart, then you need to change the X-axis minimum scale to a reasonable value.