Time Series

[carl]

I have about 30000 lines of data that looks like so:

Time Count
93000 447
93001 1020
93002 1438
93003 2177
93004 3042
93005 3467
93006 2913
93007 3341
93008 3547
93009 2908
93010 3512
93011 4090

Where ColA is time. I am having trouble creating a graph with time on the
x-axis and count on the y-axis.

Thank you in advance.

 

[Bernard Liengme]

You need to make an XY chart
But with 30,000 data points you could run into trouble; Help says you can
32,000 data points in a single data series.
However, if you want markers it will look like heck.
You could limit the data like this:
assume y-values in B2:B30001
in C2 use =IF(mod(row(B2),100)=1,B2,NA()) ' this will plot every 100th
data point
select B1:B30001; hold CTRL, select C1:C30001 and make chart

best wishes