P
PattiWagen
I have been tacking several health stats over time since the 1980s and do a
scatter plot against time. I have noticed that it does fine going through
the year 2000, but after a certain range of source data, it starts plotting
from the year 1900 and bunches my data points on the right side of the
graph. (one of the graphs it is at 20 data points) I can reduce the source
data range from either end and the graph looks fine, but I am missing data.
This happens on excel 2002 and excel 2003. Is there some way to force the
graph to use a specific range -- say 1980-2010 rather than 1900 to 2023?
scatter plot against time. I have noticed that it does fine going through
the year 2000, but after a certain range of source data, it starts plotting
from the year 1900 and bunches my data points on the right side of the
graph. (one of the graphs it is at 20 data points) I can reduce the source
data range from either end and the graph looks fine, but I am missing data.
This happens on excel 2002 and excel 2003. Is there some way to force the
graph to use a specific range -- say 1980-2010 rather than 1900 to 2023?