series and error bars

ok. this is really confusing. basically, i need to make a chart showing the average measured value of an element over the course of using 4 different bottles. the person i'm making it for wants each element grouped together so each group is one element and a different bar for each bottle.

so i made this sheet:

\1

which gives me this chart.pretend that i actually fixed the legend for you.
\1

each grouping of bars is one bottle and all the different elements are represented by different colors
then i can make the error bars, b/c each series is the same element.

but, he doesn't want that. he wants it to look like this

\1

see how each group has only 1 element and different colors represent different bottles.

to do this, i had to do something funky with the excel data, and did this:
http://myownsection.homestead.com/files/sheet2.JPG

to make each element next to each other, i had to make each series contain all the elements. B/c i did that, i can't put the error bars in anymore, bc the series is all different types of values.


i need to make the graph look like graph too, but everything i try seperates the series throughout the graph... like this
\1


i tried to make the gap between the columns smaller but as soon as i add a new series of data it seperates them again