Hi all,

I wonder if someone can help with a problem I'm having in Excel 2010.

I am using stock charts to display a ratio (as a close value) with an associated confidence interval (analogous to an error bar, using the high/low options).

However, in the chart often the marker for the close value is off-centre and it looks rather shoddy - I have attached an example.

Despite extensive googling and also looking at Jon Peltier's site, I haven't yet found a solution. Any suggestions would be very gratefully received!

graph.png

Thanks

Emily