Set the 'Error amount' option to 'Custom' and specify the range in your
worksheet that has the SDs.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have means of values that are in a line chart. I want to add error bars,
however when I add the error bars with SD=1 they all look the same. I know
the SD for each mean is not the same. I want to know how to get the error
bars to represent the SD of the data set (the set from which the mean was
derived) and not all look the same.