00:00This is how you can create an awesome target range chart looking something like this.
00:04The first thing I have to do is to create three columns. I'm going to call the first column low,
00:08another one I'm going to call it a good, and another one I'm going to call it a high.
00:13These are essentially the ranges that's going to be marked, and good is where you should be operating.
00:19And let's assign some numbers here. Say low, you're going to say 300, good, 800, maybe high,
00:25let's say 200. And you're going to take this range here, highlight them, and then basically apply them
00:31to every row like this. So now I have a chart here. This chart is actually depicting this particular
00:37data set here. Now to include this into your chart, select the new range that you have just entered,
00:44and press ctrl c to copy on the clipboard. Select the yellow line or the line chart, and press ctrl v.
00:50And this will introduce three lines in your line chart here, essentially including these three
00:56columns in your chart. So the next thing you're going to have to do is basically convert this
01:00line that you added into a stack column. Select that line chart, right click on it, and click on
01:06chart type. Make sure you're selected under the combo, and then leave the yellow one, which is the
01:12unit sold as the original one. And all this series, you're going to basically make it into a stack
01:17column like this. Okay, then once that's done, click on OK, and it should look something like that.
01:23Now basically to do a shading of the operating area, right click on any of this bar chart here,
01:30and then go format data series here, and basically change the gap width to 0% like this,
01:36and it should look something like that. Now select any of this orange ones here,
01:41and then go to this lines and fill, and basically say no fill, and go do the same thing with the orange.
01:47And say no fill. And let's make this good operating range into a green color. So I'm going to change
01:52gray to green, and there you have it. This is your target operating range.
