Managing temporal data

[silarri]

Hi everybody,

does anyone have an idea about how can I represent temporal data in
Excel? I have data such as:

Time Value
00:01 1
00:02 2
00:10 3

and I want to represent the series (time in the X-axis, and the value
in the Y-axis). The problem is that "00:01", "00:02" and "00:10" are
interpreted by Excel as categories, and they are equally spaced in the
X-axis, despite there should be a larger space between "00:02" and
"00:10" than between "00:01" and "00:02". (I already specified the
first column as containing time data, but it does not help).
Any idea about how to solve this?

Thanks in advance,

Sergio

 

[Ron Rosenfeld]

Hi everybody,

does anyone have an idea about how can I represent temporal data in
Excel? I have data such as:

Time Value
00:01 1
00:02 2
00:10 3

and I want to represent the series (time in the X-axis, and the value
in the Y-axis). The problem is that "00:01", "00:02" and "00:10" are
interpreted by Excel as categories, and they are equally spaced in the
X-axis, despite there should be a larger space between "00:02" and
"00:10" than between "00:01" and "00:02". (I already specified the
first column as containing time data, but it does not help).
Any idea about how to solve this?

Thanks in advance,

Sergio

Use the X-Y scatter graph, and select one of the solid line options.


--ron