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/
_______