Kim, I may be offering a too simple solution, but I do something similar to
what you are attempting... I think.

Plot the mean values on an x-y chart, then right click the data series on
the chart, select Format Data Series, then Y Error Bars, then highlight
"Both" by clicking on that box under "Display," click the custom and add the
corresponding standard deviation column to the plus and minus fields. It'll
create a graph with a mean and two tails representing the +/- std dev.

From there, you could customize it in any number of ways. Hope this helps.
Brad




"kimhelms" wrote in message
...
I have a chart that I just cannot figure out how to graph.
It is some survey results and the mean and standard deviation of each
question.
I want the horizontal axis to list 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0, 4.5,
and 5.0.
I want the vertical axis to list the question topic: eg, a, b, c, d, e, f,
g, h, and i.
For each question, I want to show the mean answer and the standard
deviation
on a bar, with a point for the mean and the endpoints being the +/-
standard
deviation.
Examples of the data:
Question a - Mean = 3.6875 Std. Dev. = .59387
Question b - Mean = 3.8958 Std. Dev. = .67810
Question c - Mean = 3.1875 Std. Dev. = .65730
etc.

How can I set this up to create a chart like what I need, where I
basically
have a bar that stretches plus or minus the standard deviation, with the
mean
in the center?
Thanks,
Kim