Clustered bar chart and error bars - difficulty with formatting of resulting chart

Hi,

I have four values that I'm showing on a bar chart that I want to show different sized error bars for on each bar. I finally figured out how to tell Excel where to look for the values for the error bars, and I've now successfully got it to show the different error bars using the 'custom' error amount, but my problem now is the appearance of the bar chart. As shown in the screenshot, just using the data values produces the clustered bar chart on the left (which is how I want it to look), but when I put my data in a different format to include the margin of error I want to show on the chart, while it does group them, all the bars are equally spaced apart.

charts_screenshot.jpg

I know this sounds minor, but I want the chart to look the same as the one on the left, but I've tried playing about with the 'series overlap' and 'gap width' on the series options, but I can only get the bars to become wider by altering the gap width, and series overlap doesn't seem to do anything. My concern is that with the next chart I need to produce, I have 11 pairs of bars that I need to show (each with different error bars), and if I can only get them to display with equal distances between each bar, it's going to make the chart quite difficult to read.

Am I doing something fundamentally wrong in how I have this data laid out for the chart, or is it something with the chart settings I need to change?

Thanks,

Bliss

Thank you so much! That's working perfectly, and using the same method has also allowed me to add individual error bars to the bars on the second chart I need which has 11 pairs of data. At this stage I'm not bothered whether it's elegant or not - just glad that it's working!

Thanks again for your help,

Bliss