It does allow the specification of error bars by point.

Calculate the error bar values in some column. Then, double-click the
series in the chart and in the Format Data Series dialog box select the Y
Error Bars tab (or the X Error bars tab if appropriate). In there, select
the Custom option and specify the range containing the + and/or - error
values.


--
Regards,

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

In article ,
says...
In scientific experiments it is often important to conduct an experiment in
triplicate. I find that I often need to plot these on a bar chart eg cell
number with two growth conditions at a variety of different time points. If
you count the cell number in three separate flasks for each growth condition
at each time point, then you can work out the mean cell number and the SEM or
standard deviation. I want to plot both the mean and the SD for each point by
using error bars. Obviously the SD is different for each point. Excel will
not let you do this and it makes me crazy because I have to plot cell counts
for each time point and each condition as a separate series. Why is there no
"vary error bar by point" command like there is for colour???????

Does anyone know of an easier way please?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting