View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How to create a dynamic chart using data from every 7th data row

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