plotting more than 32,000 points

  • Thread starter Thread starter jvallee
  • Start date Start date
J

jvallee

I have 60,000 data points which I need to plot. What I would rather d
is plot every other point, creating 30,000 plot points. Is thi
possible. Is there a way to copy and paste every other row to a
adjacent column without hand selecting each one
 
Suppose your data are in A1:A60000. Then, in B1, enter =INDEX($A$1:$A
$60000,(ROW()-1)*2+1). Copy B1 to B2:B30000. Plot B.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Filter your data list. First insert a column, insert this formula in the
first record:

=MOD(ROW(),2)

and fill the formula down the list (double click the small black square
at the bottom of the black outline of the selected cell). Put a table
above the data that contains your criteria range. For example, if my
table looks like this starting in row 4:

Value Criterion
1 1
2 0
3 1

the criteria range in rows 1 and 2 look like this:

Value Criterion
1

Drop down the Tools menu, select Filter, then Advanced Filter. The list
range is your data, the criteria range is either the entire criteria
range defined above, or simply the part with any values (Criteria;1).
Use Copy to Another Location, and click in a blank region.

This has just cut your data in half. Chart away.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top