close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()