| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
| Excel does not display entered values correctly | Excel Discussion (Misc queries) | |||
| return multiple corresponding values in excel | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
