+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Ralph
    Guest

    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

  2. #2
    Jon Peltier
    Guest

    Re: 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" <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




  3. #3
    Tushar Mehta
    Guest

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1