How can I plot every 65th value out of 6500 values in Excel?
 

I have data entered in 6500 cells, in size order, but only want to plot every
65th cell so as to build a representative distribution.

How can I instruct Excel to skip cells for graphing?

Thanks in advance,

Bill

How can I plot every 65th value out of 6500 values in Excel?
 

Hi,

Here are a couple of approaches to the problem.

http://pubs.logicalexpressions.com/P...?ID=209#jon024
http://www.tushar-mehta.com/excel/ne...ers/index.html

Cheers
Andy

Bill Viverette wrote:
I have data entered in 6500 cells, in size order, but only want to plot every
65th cell so as to build a representative distribution.

How can I instruct Excel to skip cells for graphing?

Thanks in advance,

Bill

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info