Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula used by Excel to determine y-axis interval in chart | Excel Discussion (Misc queries) | |||
Need to know the logic for determining the interval between Y axis labels | Charts and Charting in Excel | |||
time interval calculation | New Users to Excel | |||
Time interval worksheet function | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) |