Managing temporal data

  • Thread starter Thread starter silarri
  • Start date Start date
S

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
 
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
Click to expand...

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


--ron
 
Back
Top