If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
Can series tool change formulas over time when used to copy them | compu_trainer | Worksheet Functions | 3 | May 26th, 2005 07:55 PM |
Ineffective change of plot order in series formula | Jon Peltier | Charts and Charting | 3 | May 30th, 2004 02:15 AM |
time zone & apt times auto changing | Mary | Calendar | 6 | May 25th, 2004 05:44 AM |
One chart that shows one data series out of ten at a time | Joseph Sichelstiel | Charts and Charting | 2 | November 18th, 2003 05:28 PM |