Help Excel and Error Bars

[Vladamir]

Aloha

I'm trying to put together a graph in excel with 4 data points. These points are plotted based upon some average values with +/- standard deviations.

I've tried to add some Y-error bars, but when i do i don't seem to be able to add in an error bar for a single data point - it's only allowing me to add a single-size error bar across all my data points when the standard deviations are different for each data point.

Is it possible to add a standard deviation bar for each data point? Each one has a different SD so quite honestly i need to try and do them separately! I'm using excel 2003 for the record.

Cheers meights!

 

[Lenore]

Been having to do this kinda stuff for my dissertation.

You need to set up the SD results how u set up the excel table like..

Actual Results
Arboreal Terrestrial
Keli 26.54 45.62
Mutu 41.31 31.08

SD
Arb Terr
keli arb 6.388 3.685
Mutu arb 6.806 6.905

Then do the whole select customised thing in excel error bars and it should work! (tables didnt copy n paste well over into this but hope u get the picture!)

 

[Vladamir]

Figured it out now, cheers man