Solved excel only plots 32000 data points

September 26, 2014 at 00:24:35
Specs: Windows 7
how can i plot 400000+data points onto a scatter graph
I was thinking i could plot ever 10 or 15 row ?
So I need a formulea that will plot every 10 or 15 th row.

See More: excel only plots 32000 data points

Report •


#1
September 26, 2014 at 04:04:02
✔ Best Answer
Without knowing anything about how your data is laid out or what you are trying to plot, it's hard to offer a specific solution. We may need some more detail.

How about this...

If the original data is in A1:A400000, create a "helper column" with the formulas:

=A1
=A16
=A31
etc.

Now plot the helper column.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question