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

Originally Posted by blindtheskies

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

Hi,

.jpg's are nice, but a sample .xls would give some idea of what caused the picture, and a suggestion of how to fix it.

The attached has two charts, one by Columns, the other by Rows, I think this is the setting you are looking for.

hth
---

Originally Posted by blindtheskies

sorry, i'm new to this type of forum. i'm going to look at that file and see it it works. thank you so much

Hi,

The 'gap' at zero does work.

If you are continually adding new data, you can (on my sample) select A1:M5 and Insert Chart, next, next, next, as New Sheet
you can then select the chart, Tools, Options, Chart, and set Plot visible cells only, and hide the columns not yet in use.

You can then unhide each new column as required.

This can help with some settings.

hth
---