Help with excel charts needed!!

[wood11115]

Hello, I am doing my dissertation and having trouble with excel charts. I need to make a chart with confidence intervals. I have 3 means that I need to put into a chart (each titled differently) and add in the lower and upper confidence intervals but seem to be unable to do this. I ahve my means and confidence intervals already so the help thats needed is only to do with inputting them into a chart.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Any help would be greatly appreciated. <o></o>
<o></o>

Thanks<o></o>

 

[VoG]

Perhaps you could use error bars http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

 

[wood11115]

Hello, thanks for your help but it seems with error bars that they have to all be the same value I think? My confidence intervals are all different values so I need to be able to do each mean individually.

 

[VoG]

In the link that I posted scroll down to Custom Error Bar Values. I think that will do what you want.