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