|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 7th, 2009, 08:15 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Create a data point series
How do I create a data series of every third (3rd) data point in a long string?
|
|
#2
March 8th, 2009, 01:53 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create a data point series
Is this what you want?
Decimating the Data (Plotting Every Nth Point) http://pubs.logicalexpressions.com/P...?ID=209#jon024 If you just want the sparse array of points, you can skip the line series and use the formulas which put #N/A is all but the Nth cells, or use other formulas which pull the data from every Nth cell into an adjacent column. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Joseph" wrote in message ... How do I create a data series of every third (3rd) data point in a long string?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
