Question

	OBESITY			SMOKER			ALCOHOL - (heavy drinking more than once a month)			Physical Inactivity (during leisure time)
	%	LCI	UCI	%	LCI	UCI	%	LCI	UCI	%	LCI	UCI
Q1 - least deprived	18.28	11.69	27.42	16.75	11.13	24.44	15.34	9.153	24.57	47.56	32.32	63.28
Q2	21.3	14.95	29.41	21.12	15.04	28.82	22.41	10.61	41.29	40.26	31.43	49.76
Q3	23	16.18	31.61	21.62	15.96	28.59	25.39	18.67	33.52	43.06	35.82	50.6
Q4	23.99	16.58	33.38	26.17	17.97	36.46	21.07	11.86	34.62	50.79	40.02	61.48
Q5 - most deprived	28.36	21.57	36.3	25.25	16.58	36.49	21.2	15.7	27.99	43.48	35.65	51.65

I have these numbers and am asked to create a bar chart with error bars in excel for the confidence intervals and am only given this data... how do I make this bar char with confidence intervals ! The percentages are what is to be graphed, it is assumed they are the mean. THE DATA IS IN A COPIABLE FORM. I COPIED AND PASTED STRAIGHT FROM HERE INTO EXCEL!

Answer 1

Put the data in the form shown in 2nd table, select the data and select insert 'stacked column chart'

To add error bars, select 'Add chart elements' -> error bars ->more error bars option

select a variable from the window, in the window that would open in right side, select 'both' and 'specify values'

specify positive error (UCI) and negative error (LCI)

Repeat the process for each variable and you should get a similar chart below