I have a Line chart that plots the value of my investments on the y axis then
the date on the x axis. I experience the problem that when I go into source
data and try to extend the date range I end up with a graph that has plain
numbers on the x axis and the dates are now on the y if you then put the
mouse on a date point it brings up a monetery value for that point while the
mouse is over that point.

How do i keep the dates on the x axis and the value on the y. Is it
something to do with a maximum number of data points on the y axis