How to add deviations into your chart

To create a chart with deviations, do the following:
1. Select the data range (in this example A4:C12).

2. Select Insert -> Chart... to open the Chart Wizard dialog box:

Choose the Line type, the Line sub-type and then click Next >.
3. In the Step 2 of Chart Wizard check the data and click the Next > button.
4. In the Step 3 of Chart Wizard, enter a title in the Titles tab, hide the legend in the Legend tab and then click Next >.
5. In the Step 4 of Chart Wizard, click the Finish button.
6. Right-click one of the years along the category axis. In the popup menu select Format Axis...:

In the Format Axis dialog box, on the Number tab, change the field Format Code (in example to show only month and year) and click the OK button:

7. Right-click in the chart line. In the popup menu select Format Data Series...
8. In the Format Data Series dialog box, on the Patterns tab, click the Smoothed line checkbox:

9. Click the Y Error Bars tab in the Format Data Series dialog box to display the error bars options.
- In the Display group the Plus option - to show the actual data point value plus a specific error amount;
- In the Error Amount group, the Custom: option, and then in the
Specify Value use values in a worksheet range that you specify as error amounts (in this
example D4:D12):
10. Right-click in the error bars. In the popup menu select Format Error Bars...

11. In the Format Error Bars dialog box, on the Patterns tab, select the error bars options:

You can then make any other adjustments to get the look you desire.