+ Reply to Thread
Results 1 to 3 of 3

Dynamic graph range - only want to select certain data

  1. #1
    Registered User
    Join Date
    03-11-2015
    Location
    NC, USA
    MS-Off Ver
    2010
    Posts
    6

    Dynamic graph range - only want to select certain data

    I create graphs from a machine that exports text files. The machine cycles up and back down (basically starts and ends at 0). What I'm trying to do is eliminate the down part of the graph. I'd like to just graph the data on the "up" cycle, where it reaches it's max travel.

    The problem is that the max travel is not always the same for each run. The data range is always changing. The data is always placed in the same columns, just the number of rows change depending on how much data was gathered.

    What I'm looking for is a function that will look at my data columns and only select the range that goes up to max travel.



    Thanks in advance,

  2. #2
    Forum Contributor
    Join Date
    06-11-2014
    MS-Off Ver
    Office 2003, 2007 & 2010
    Posts
    119

    Re: Dynamic graph range - only want to select certain data

    Could you post an example set of data and indicate the max run phase please?

  3. #3
    Registered User
    Join Date
    03-11-2015
    Location
    NC, USA
    MS-Off Ver
    2010
    Posts
    6

    Re: Dynamic graph range - only want to select certain data

    I have attached a graph with the table. .

    Here is some better explanation. The data tables, which starts at column U is created by entered in what data set number I want to graph in either B17 or C17.

    The max run point will be based on the Pad1_L, Pad2_R etc columns. I want a function that will look down these columns and stop at the max value. The other issue is max data value is usually repeated several times as the machine stops at this point for a period of time (while still recording the same data). I know there is a way for the function to look only at the first instance of max value which is probably what would work best.

    So for the Pad1_L the max value I'd like to graph is only from U6 to U96 (which is the Y axis) then graph the corresponding X values (V6 to V96). And as I stated these ranges will change, as you can see for the Pad2_R which has a max value at cell W93.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic range for graph not picking up new data
    By Trevasaurus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2013, 06:03 PM
  2. Dynamic Range Graph with data in separate file?
    By gapollo in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-29-2013, 09:44 AM
  3. How to add a named range of dynamic data to a graph
    By mashoutposse in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-31-2010, 08:57 PM
  4. [SOLVED] Dynamic Range with unused formula messing up x axis on dynamic graph
    By cabybake@yahoo.com in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-02-2006, 04:10 PM
  5. Replies: 6
    Last Post: 01-25-2006, 02:45 PM

Tags for this Thread

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