x-axis time interval
 

Trying to plot mortality rates per 5 year blocks, i.e. 1951-1955, 1956-1960.
Can't get scatter plot to display those specific intervals. Rather, it
simply labels the time points by the number cell in which the interval was
typed, i.e. 1, 2.
thanks

x-axis time interval
 

A scatter chart needs numerical values. Try a line chart, which will treat
the text "1951-1955" etc as labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John" wrote in message
...
Trying to plot mortality rates per 5 year blocks, i.e. 1951-1955,
1956-1960.
Can't get scatter plot to display those specific intervals. Rather, it
simply labels the time points by the number cell in which the interval was
typed, i.e. 1, 2.
thanks