Graphs with confidence Intervals

Morning,

I'm to create the graphs on page 2 of the attached document. Basically the line has a point, and then has an upper and lower confidence interval. I can't seem to find a way to do this in Excel, so any help would be appreciated.

When I've tried the stock graphs it doesn't allow me to create them in the exact format of the attached document, e.g. different colours for different lines, a middle dot to show where the value is, etc.

Many thanks for any help you can give.

Apologies in the 'other charts' section I can't seem to find the 'Box and whisker' only the 'high open low close'. Do I need to do anything else to get them to show?

Thanks