Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error bars on a graph
I am using Excel 2003, and I am trying to put error bars on my standard 2-D
bar graph. The graph is for a research project looking at pretest and posttest averages for a group of 4 people concerning performance on several outcome measures. We have had a statistician run our results, and I have the specific numbers I want to put on each pretest and posttest bar. I have found how to insert the error bars, and how to input custom values, but it applies the standard deviation to the whole series. In actuality, the standard deviation is different for each measure. Is there a way to put in the individual standard deviations on each seperate bar in the graph? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error bars on a graph
I actually just found a few posts below mine was asking the same question.
It was helpful and solved my problem. Sorry for the re-posting. "moviegal488" wrote: I am using Excel 2003, and I am trying to put error bars on my standard 2-D bar graph. The graph is for a research project looking at pretest and posttest averages for a group of 4 people concerning performance on several outcome measures. We have had a statistician run our results, and I have the specific numbers I want to put on each pretest and posttest bar. I have found how to insert the error bars, and how to input custom values, but it applies the standard deviation to the whole series. In actuality, the standard deviation is different for each measure. Is there a way to put in the individual standard deviations on each seperate bar in the graph? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph bars are sticking | Excel Discussion (Misc queries) | |||
Re-size Bars in Bar Graph | Charts and Charting in Excel | |||
Sort bars in a graph | Excel Discussion (Misc queries) | |||
How do I graph 2 bars with 2 different axes? | Charts and Charting in Excel | |||
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? | Charts and Charting in Excel |