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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I tell excel not to plot certain values in a data series	Tom	Microsoft Excel Misc	1	17th Aug 2009 08:54 PM
Calculate date - 1st of the month following 65th birthday - EXCEL	=?Utf-8?B?Sm9hbg==?=	Microsoft Excel Misc	4	23rd Mar 2007 05:14 PM
How do I plot non-numeric values in a graph in Excel?	=?Utf-8?B?TGF4?=	Microsoft Excel Charting	1	30th Jul 2005 04:21 PM
Can you plot a graph with 3 axes e.g. xyz values on Excel?	=?Utf-8?B?S2hhbg==?=	Microsoft Excel Charting	2	29th Jul 2005 01:40 PM
BUG?: Excel scatter chart: will not plot x-values	Bob	Microsoft Excel Misc	2	31st Dec 2004 12:19 AM