What do you use to generate graphs?
rsn_ at _comcast.net
Thu Sep 18 20:24:27 EST 2003
Many thanks for this thread -- it made me finally learn how to do
error bars in Excel!
It works just as well for scatter plots. Just arrange your data in
columns, say (rows works equally well). Of course the independent
variable goes in one column, the means of the dependent variable in a
second and the error term (1 or 2 standard errors or standard
deviations or whatever you want) in a third.
Make the usual plot of y vs x using the first two columns for data.
Then right click on a data point to bring up "Format Data Series"
menu. Incidentally, all this is Microsoft Office 2000. Select the
page Y-Error Bars and select the "Both" if you want both up and down
bars. Then select the Custom choice. In both the window for + and
for - you can merely select with the mouse the column of data with
your calculated error values.
This was all spelled out in pieces in earlier posts. but I wanted to
get it all on one place. It is not necessary to enter the numbers for
the error terms, just select the cells that contain the values. You
end up with something like:
to mean the error values are in worksheet 1, cells M18 through M22.
Probably entering a "range formula" would also work, if I could ever
figure out how to do that!
On Thu, 18 Sep 2003 21:28:30 -0300, "NMF" <neil.fournier at sympatico.ca>
>Double click on the actual bars of the bar graph (generally this will select
>all of them). Then a submenu will come up and there will be an option for
>y-error bars. Click on that. Then the submenu contents will change. There
>should be a section that has the word: custom with both a plus and negative
>(on separate lines). All you have to do is type in the values for the SEM
>in the box. Each value must be followed by a semicolon (i.e
>14.567;16.754;13.609). These three values would correspond to three
>different groups in a bar graph. (if there was only two bars then obviously
>all you would need to input are two SEM i.e. 14.567;16.754). That's it.
>You must use CUSTOM in order to have each error bar specifically set for
>each group otherwise it will give you error bars that are all the same for
>Instead of manually typing them in you could highlight the SEM (you must
>have them calculated) and I think a copy and paste will work. You have to
>fiddle with it (as you highlight them the values will appear in the custom
>Let me know how the other stats program you downloaded works.
>"BilZ0r" <BilZ0r at TAKETHISOUThotmail.com> wrote in message
>news:Xns93FADEEDDE1A1BilZ0rhotmailcom at 188.8.131.52...
>> I don't udnerstand, when ever I input error bars, say I've got a bar
>> It only lets me input the error once, and then it applies it to the whole
>> And what do you mean about the semi colons, it things the input is text if
>> I used semicolons
>> "NMF" <neil.fournier at sympatico.ca> wrote in
>> news:Ttaab.2247$Ie5.491957 at news20.bellglobal.com:
>> > What do you mean? Excel plots error bars perfectly. Double-clicking
>> > on the graph bars itself will cause a submenu to open
More information about the Neur-sci