Standard deviation error bars don't fit the specified values, are instead an order of magnitude larger.

EDIT: SOLVED
Solution was making sure that the negative and positive stdev corresponded to the same range. by default, the negative is set to one. not too sure what any of that means, but it worked.
---
Hello, I've been trying my best to add standard deviation error bars to my data. I am on Mac.

Raw data and graph

However, as is evident in the image, these error bars are abnormally large. They are meant to match up with the "Average" column of the table at the top, but they obviously do not.

My steps were as follows:

1. Select the pH column and the Average column and insert a graph (A14:19 and H14:H19, respectively)
2. Chart Design > Select Data. Set Y values to H14:H19 and Horizontal (category) axis labels to A14:A19. The filled out dialogue box is shown in the second image.
3. Chart Design > Add Chart Element > Error Bars > Standard Deviation
4. Open Chart Format
5. Click on the error bars within the graph (which opens the "Format Error Bars" menu)
6. Change the error bars from Standard Deviation(s) to Custom
7. Select I14:I19 (the "StDev" column) as the data range for the Standard Deviation values.

The \"Select Data\" dialogue box

I have also tried changing the cell format of the StDev column "Number"; placing the values in a row rather than a column, and selecting that instead (D38:I38 in the first image), but to no avail. Any help is appreciated!