Changing X-axis label

[Si14]

Hi,

My data is in one column (Column A), and I used "2-D Line graph" style to plot the data versus "row number".
The data is plotted for say 100 points.
The data is captured every 200ms, that means the overall plot is (100 points * 200ms=) 20second.
- I wonder how to convert the X-axis label from numbers (1 to 200) to second?

Thanks.

 

[tusharm]

Move column A to B. Now, suppose your data start in row 2 (row 1 contains headers). Then, in the now empty A, enter the values you want (if you want milliseconds, enter 0 in A2, and in A3 =A2+200. Then, copy A3 as far down as you have data in B. Now, plot A2:B{n} as the chart.

Hi,

My data is in one column (Column A), and I used "2-D Line graph" style to plot the data versus "row number".
The data is plotted for say 100 points.
The data is captured every 200ms, that means the overall plot is (100 points * 200ms=) 20second.
- I wonder how to convert the X-axis label from numbers (1 to 200) to second?

Thanks.