topic How to set changing upper/lower limit lines on graph builder in Discussions

How to set changing upper/lower limit lines on graph builder

bgeaibreyi — Fri, 08 Jun 2018 18:38:34 GMT

Hello,

I have a simple Y vs X graph that the upper limit and lower limit are changing at different X values. Does anyone know how to do this on Graph Builder? or if there's a better way to do it?

Thanks,

Gary

Re: How to set changing upper/lower limit lines on graph builder

cwillden — Fri, 08 Jun 2018 18:49:50 GMT

Can you provide an example with Fit Y by X that you want to reproduce in Graph Builder? I'm not sure what you're referring to.

Re: How to set changing upper/lower limit lines on graph builder

bgeaibreyi — Fri, 08 Jun 2018 18:56:45 GMT

I'd like to produce something like attached with the two red lines being the reference lines changing against X.

Re: How to set changing upper/lower limit lines on graph builder

cwillden — Fri, 08 Jun 2018 23:14:55 GMT

This looks like an UWMA control chart. You can get something like this in Graph Builder if you make the limits of X another series along with the actual data. Here's what the result looks like.

I made the series for the upper and lower limits and simulated data, then I stacked them to get them into a single column with labels. See the attached data tables.

Re: How to set changing upper/lower limit lines on graph builder

bgeaibreyi — Fri, 08 Jun 2018 23:54:01 GMT

Good idea! this should work for me! thanks!