Does anyone know how to change the error bars so that they represent the standard error for each data point? I can only get it to do the error bar for all the data points
Sounds like you need to use the Custom +/- option on the Error bars
dialog. This allows you to specify a value for each data point.
Obviously you will need to have the standard error values either stored
in cells or enter the values as a array.
