I am wondering if there is a good way to use Excel for a datasheet that has over 50000 rows and 2 columns. I want to make a graph but because of the amount of data the graph is not showing any usuable data. Any ideas?
I am wondering if there is a good way to use Excel for a datasheet that has over 50000 rows and 2 columns. I want to make a graph but because of the amount of data the graph is not showing any usuable data. Any ideas?
Could you show a subset of the data?
Like every 100 rows or something.
Hope this is what you meant
5:00:01 PM 142
5:00:06 PM 141
5:00:07 PM 140
5:00:08 PM 141
5:00:09 PM 142
5:00:13 PM 143
5:00:18 PM 137
5:00:19 PM 138
5:00:20 PM 139
5:00:21 PM 139
5:00:22 PM 139
5:00:23 PM 139
5:00:26 PM 160
5:00:28 PM 134
5:00:29 PM 145
5:00:30 PM 136
5:00:32 PM 153
5:00:33 PM 143
5:00:35 PM 141
5:00:38 PM 142
5:00:39 PM 139
5:00:40 PM 140
5:00:41 PM 144
5:00:45 PM 139
5:00:51 PM 139
5:00:54 PM 138
5:00:55 PM 137
5:00:56 PM 138
5:00:59 PM 137
5:01:00 PM 138
5:01:02 PM 140
5:01:05 PM 140
5:01:07 PM 141
5:01:08 PM 144
5:01:09 PM 144
5:01:10 PM 137
5:01:13 PM 127
5:01:15 PM 156
5:01:15 PM 164
5:01:16 PM 179
5:01:18 PM 183
5:01:19 PM 173
5:01:21 PM 214
5:01:22 PM 193
5:01:23 PM 191
5:01:24 PM 192
5:01:25 PM 192
5:01:26 PM 192
5:01:27 PM 192
5:01:28 PM 191
5:02:17 PM 166
5:02:19 PM 158
5:02:20 PM 156
5:02:21 PM 157
5:02:22 PM 151
5:02:23 PM 163
5:02:24 PM 174
5:02:25 PM 169
5:02:26 PM 135
5:02:27 PM 199
5:02:28 PM 202
5:02:29 PM 213
5:02:31 PM 206
5:02:32 PM 204
5:02:33 PM 178
5:02:34 PM 183
5:02:34 PM 180
5:02:36 PM 182
5:02:37 PM 182
5:02:38 PM 183
5:02:39 PM 182
5:02:40 PM 181
5:02:41 PM 180
5:02:42 PM 180
5:02:44 PM 181
5:02:46 PM 180
5:02:47 PM 182
5:02:48 PM 180
5:02:49 PM 180
5:02:53 PM 180
5:02:55 PM 182
5:02:56 PM 182
5:02:57 PM 181
5:02:58 PM 182
5:02:59 PM 181
5:03:00 PM 181
5:03:01 PM 180
5:03:02 PM 181
5:03:03 PM 179
5:03:04 PM 176
5:03:05 PM 178
5:03:06 PM 178
5:03:07 PM 178
5:03:09 PM 179
5:03:10 PM 179
5:03:11 PM 179
5:03:12 PM 181
5:03:13 PM 179
5:03:15 PM 181
Not really.
I meant in your chart do you need to show every data point or could you get away with showing ever other point, or every point in 10.
Looking at your data maybe showing the data points between time slots.
So all data points between 5pm and 6pm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks