Thread: 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

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" <Ralph@discussions.microsoft.com> wrote in message
news:A82A2E2D-7077-4394-BB0A-99BF514C4C63@microsoft.com...
>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

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 <A82A2E2D-7077-4394-BB0A-99BF514C4C63@microsoft.com>,
Ralph@discussions.microsoft.com 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
>