How to create a dynamic chart using data from every 7th data row
 

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

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

How to create a dynamic chart using data from every 7th data row
 

In addition to Jon's link, you may also want to check
Select Markers
http://www.tushar-
mehta.com/excel/newsgroups/only_some_markers/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
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