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

R

Ralph

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indenting every other paragraph in Word at the same time? 0
Creating a Chart on form from selected data in query. 0
Need Help with a VBA subroutine 0
How to create a bubble chart with more than 2 variables. 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Dynamic (?) chart 0
Returning every 7th row of a column 8
Chart SERIES OFFSET 5

Top