To show one way without changing the values itself:
Make A1:E1 to
y,-SD,Mean,+SD,Value. A2:E2 would be
0,21,25,29,26. A3 is 1 and B3:E3 will be the same as B2:E2.
The sheet should look like this:
Now select the whole range (A1:E3) and hit scatter chart in the insert tab.
Do not get confused, you will get a chart which looks like this:
Now we right click the chart and hit "Select Data..."
In the new window we hit the middle button "switch row/column" so the chart looks like this:
This is already pretty close to what we want. To transpose it (so it looks like your picture) we need to switch all x and y values (which is a bit more of work). We again go to the "Select Data..." window. There simply select the first series (should be
-SD) and hit edit to get another window holding the data:
We now need to set the "Series X Values:" to the range which is in "Series Y Values:" and vice versa. The series name should not be changed (it is easier to know which "line" is which).
We need to to do this "switch" for each series. so in our example the y values always should be
=Sheet1!$A$2:$A$3. After all of that is done, the chart should look like this:
All that is left is formatting. Hide gridlines/legend/scales, change colors for the series all that stuff. I also suggest switching the the "values series" to first position in the "Select Data..."- window (so if the value is the same to +/-SD or Mean it doesn't "vanish" behind it). If everything is done, then it can look like this (just format it to fit your needs):
A copy of the Workbook is HERE.
If you have any questions, just ask ;)