x-axis time interval

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
A scatter chart needs numerical values. Try a line chart, which will treat
the text "1951-1955" etc as labels.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

showing start of each month as tick mark & label on X-Y chart 1
Setting x axis scale to time with variable intervals 1
Urgent Help Needed: X axis to scale 2
Time / Date on X axis 2
Plotting Date and Time on the same chart axis 1
Excel 2007 - change interval between labels on X axis 3
monthly separation tick marks on x-axis 10
X-axis should read 20,000 years to 0 in intervals of 5,000 0

Back
Top