Here's one way:
http://pubs.logicalexpressions.com/P...?ID=209#jon024
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Ralph" wrote in message
...
I have a spreadsheet of with multiple rows of data based on dates. I need
to
build a dynamic chart that only uses data from every 7th row. To date all
I
have been able to find is going through the whole spreadsheet and marking
data in every seventh row. Any suggestions