Chart with upper and lower control limits

In this Excel tutorial you will teach yourself how to create a chart with upper and lower control limits.Let’s begin from preparing data table.data tableHighlight data table. Go to the ribbon to the Insert tab. Choose a Line chart.

ribbon line chart

Your chart should like similar to this one.

basic line chart

Right click first lower limit line and choose Format Data Series from the menu.

Format Data Series

Change line color to red and set width to 5 pts.

format lower limit line

Do the same for upper limit line. Change chart title. Your chart with upper and lower control limits is ready.

chart with upper and lower control limits

Template

You can download the Template here – Download