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
Hi,
Here are a couple of approaches to the problem.
pubs.logicalexpressions.com/P...?ID=209#jon024
www.tushar-mehta.com/excel/ne...ers/index.html
Cheers
Andy
Bill Viverette wrote:
gt; I have data entered in 6500 cells, in size order, but only want to plot every
gt; 65th cell so as to build a representative distribution.
gt;
gt; How can I instruct Excel to skip cells for graphing?
gt;
gt; Thanks in advance,
gt;
gt; Bill
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
- Oct 05 Fri 2007 20:39
How can I plot every 65th value out of 6500 values in Excel?
close
全站熱搜
留言列表
發表留言