I will try my best to explain my problem.
I have the following data:
[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]SD(minus)[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]Mean[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]SD(plus)[/TD]
[TD="class: xl65, width: 64"]Points[/TD]
[/TR]
[TR]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]19.1[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]28[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]36.99[/TD]
[TD="class: xl65"]39[/TD]
[/TR]
[TR]
[TD="class: xl65"]B[/TD]
[TD="class: xl65"]7.92[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]12.6[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]17.28[/TD]
[TD="class: xl65"]10[/TD]
[/TR]
[TR]
[TD="class: xl65"]C[/TD]
[TD="class: xl65"]14.04[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]19.7[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]25.36[/TD]
[TD="class: xl65"]25[/TD]
[/TR]
[TR]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]10.68[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]16.1[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]21.52[/TD]
[TD="class: xl65"]15[/TD]
[/TR]
[TR]
[TD="class: xl65"]E[/TD]
[TD="class: xl65"]7.68[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]12.4[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]17.12[/TD]
[TD="class: xl65"]17[/TD]
[/TR]
[TR]
[TD="class: xl65"]F[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]9.5[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]12[/TD]
[TD="class: xl65"]13[/TD]
[/TR]
</tbody>[/TABLE]
I have to now plot the points (see last column) something similar to the following:
Please note that the point plotting starts with the mean and goes from SD(minus) to SD(plus) depending on the points to plot. The first 3 columns will remain fix. I have to plot the points based on the 4th column (Points).
Any ideas how can I do this in Excel? Is there a better way to graphically represent what I want?
I have the following data:
[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]SD(minus)[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]Mean[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]SD(plus)[/TD]
[TD="class: xl65, width: 64"]Points[/TD]
[/TR]
[TR]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]19.1[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]28[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]36.99[/TD]
[TD="class: xl65"]39[/TD]
[/TR]
[TR]
[TD="class: xl65"]B[/TD]
[TD="class: xl65"]7.92[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]12.6[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]17.28[/TD]
[TD="class: xl65"]10[/TD]
[/TR]
[TR]
[TD="class: xl65"]C[/TD]
[TD="class: xl65"]14.04[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]19.7[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]25.36[/TD]
[TD="class: xl65"]25[/TD]
[/TR]
[TR]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]10.68[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]16.1[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]21.52[/TD]
[TD="class: xl65"]15[/TD]
[/TR]
[TR]
[TD="class: xl65"]E[/TD]
[TD="class: xl65"]7.68[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]12.4[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]17.12[/TD]
[TD="class: xl65"]17[/TD]
[/TR]
[TR]
[TD="class: xl65"]F[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]9.5[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]12[/TD]
[TD="class: xl65"]13[/TD]
[/TR]
</tbody>[/TABLE]
I have to now plot the points (see last column) something similar to the following:
Please note that the point plotting starts with the mean and goes from SD(minus) to SD(plus) depending on the points to plot. The first 3 columns will remain fix. I have to plot the points based on the 4th column (Points).
Any ideas how can I do this in Excel? Is there a better way to graphically represent what I want?