Graphing dynanic range only up to maximum value

[mullenmg1986]

I have a chart that changes dynamically with data that is entered on another sheet. I then make a scatter plot from this chart. The data goes from 0 to a maximum value (which is what is always changing) then returns back to zero.

I want the graph to ignore the returning or down slope of the graph without having to go in and re-select the data after the chart has been dynamically set.

I've thought of using a VLOOKUP function but I can't figure out how to have it select the data from my first point up to the max only. Also thought there is a possibility using Name Manager but couldn't figure out how to input it all.



Thanks in advance!

 

[Smitty]

Welcome to the Board!

You could try using AutoFilter to only display values below your maximum value.

 

[mullenmg1986]

I don't think that will work. I have multiple data selection on this graph with each having a different maximum value. My goal for the graph is that once the chart is filled with my dynamic data, it will look at the data, find the maximum for each plot and only graph up to that point and ignore the rest of the data.


Thanks,