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 •

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:


Now plot the helper column.

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

Report •
Related Solutions

Ask Question