data range - selective rows

Holly · Dec 11, 2003

How do I choose every ninth row to be my Y data on a
chart? I have 15,000 rows so picking one individually
will be time consuming.

Thank you.
Holly

Debra Dalgleish · Dec 11, 2003

Jon Peltier has instructions for this in his Excel Charting FAQ article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024