The final tolerance chart should look something like this: You may now format the left axis, Min, Max and Result on the chart to display as you wish. Within the Format Axis window select Axis Options -> Position Axis: – On tick marks Change the fill for this section to ‘No Fill’. From the menu select “Format Data Series”. Next, right click on the bottom area (the Min).
SCATTER CHART EXCEL UPPER BOUND LIMIT SERIES
Please note, in other versions of Excel it is necessary to right click on the data series you wish to change, then changing the data series one by one to the chart type you wish. The Min and Range should remain as Stacked Area charts From the menu select “Change Series Chart type. Next, right-click the data series relating to the Result (yellow in the screenshot above). Next, delete the title and the legend (unless you specifically require them). We now need to add the minimum result into the chart again (this will form one of the thick borders of the acceptable range). The principles for other versions of Excel will be the same, but the menus may be in slightly different locations.Ĭlick: I nsert -> Charts -> All Charts -> Area -> Stacked Area This example is created using Excel 2016.