Setting Upper and Lower Limits in Excel Charts

Charts in Excel are one of the best tools for visually presenting data. In some instances, we want to have upper and lower limits to our chart to see where our existing values fall in that picture.

In the example below, we will show how to do this.

Upper and Lower Limits in Excel Charts

In the example that we want to create, we will create all the values manually. We will have three columns: one with sales figures, the second with upper limits, and the last one with lower limits.

Graphical user interface, application, table, Excel

Description automatically generated

These figures are completely arbitrary. For the next thing, we will select the whole table, and then go to Insert >> Charts >> 2-D Line:

Graphical user interface, application, table, Excel

Description automatically generated

When we hover over it, we will see the preview of the chart that will be created, and once we click on it, this is what we will have:

Chart, line chart

Description automatically generated

We will change the chart title to Sales figures and Limits, then choose the upper limit line, right-click on it and then choose Format Data Series:

Chart, line chart

Description automatically generated

Once clicked, we will see the Format Data Series window. In there, we will choose Fill & Line option, change the color to red, and increase the width to 3.5 pt:

Chart, line chart

Description automatically generated

We will do the same thing with lower limits, and this is what we will end up with:

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.