How do I set up an error bar in Excel and a vertical line together
 

I would like to create a graph/ macro that will calculate and draw the
confidence intervals( errors bars ) for different groups of people,
incorporated with a vertical line that will show the mean.

How do I set up an error bar in Excel and a vertical line together
 

Turn on a macro...
TOOLS / MACRO / RECORD NEW MACRO
Create the graph by hand the first time and use this macro as your template
for future graph/ macro creations.
HTH,
Gary Brown




"UserDefinedGraph" wrote:

I would like to create a graph/ macro that will calculate and draw the
confidence intervals( errors bars ) for different groups of people,
incorporated with a vertical line that will show the mean.