Thread: Time Series
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Time Series

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"carl" wrote in message
...
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.