Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time Series
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
excel money addin should have time series data | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
prehistoric time series | Excel Worksheet Functions |