Combining separated columns?

[RaineeDays]

I have data as shown below:

Long Grass Short Grass Concrete
0.274760448 0.516761782 0.377166667
0.226014478 0.304869311 0.406190102
0.192857171 0.712843314 0.502123457

What I need is one separate column for long, one for short and one for
concrete so I can directly compare them, with error bars and the like.
However, when I graph these, they are separated, with the first line as a set
of 3 columns, the second line as the next set and so on. How do I make only 3
columns to compare them??

Thanks.

 

[Jon Peltier]

How are you analyzing them? I see three columns, each with three rows of
data.

- Jon

 

[RaineeDays]

Sorry I probably wasn't very clear. I need to create a column chart for the
data. I need all of the Long grass data in one column on the graph, and one
for short and one for concrete. When I graph the data I get 9 separate
columns, one each for each of the values in the data set. I need to compare
the totals of each of the three separate treatments (long/short/concrete) and
have error bars. I used to have Excel 2003 and have updated to 2007 - I know
there is a way to do it.. But i just dont remember how i managed to do it in
the 2003 version.

Hopefully you understand what I am trying to achieve!

Laura

 

[Del Cotter]

Sorry I probably wasn't very clear. I need to create a column chart for the
data. I need all of the Long grass data in one column on the graph, and one
for short and one for concrete. When I graph the data I get 9 separate
columns, one each for each of the values in the data set. I need to compare
the totals of each of the three separate treatments (long/short/concrete) and
have error bars. I used to have Excel 2003 and have updated to 2007 - I know
there is a way to do it.. But i just dont remember how i managed to do it in
the 2003 version.

Hopefully you understand what I am trying to achieve!

We see what you want the columns to mean, we don't see what you want the
rows to mean. Restate your matrix as follows:

Long Grass Short Grass Concrete
A 0.274760 0.516761 0.377166
B 0.226014 0.304869 0.406190
C 0.192857 0.712843 0.502123

Where "A", "B", and "C" should be labels explaining the meaning of the
rows.

 

[Jon Peltier]

If you want to plot a sum, calculate the sum in the worksheet, then plot the
calculated value. If you want something else, you need to explain it better.

Also what is the significance of error bars to a sum?

Perhaps you want to plot an average, and use error bars to denote the
standard deviation? Use the AVERAGE() and STDEV() worksheet functions. It
will look something like this:

Long Grass Short Grass Concrete
Obs 1 0.274760448 0.516761782 0.377166667
Obs 2 0.226014478 0.304869311 0.406190102
Obs 3 0.192857171 0.712843314 0.502123457
Average 0.231210699 0.511491469 0.428493409
StDev 0.041198146 0.204038058 0.065395932

Then make a plot using the headers (Long Grass, etc., essentially B11 in
my little table above) and the data (B55), then double click the series,
click on the Error Bars tab, click in the Custom (+) box and select the
range with the STDEV for the three columns (B66), then click in the Custom
(-) box and select the same range.

- Jon

 

[RaineeDays]

Ahh.. success. For some reason I thought it had to do with formatting the
chart.. It has been a long time since doing these things. So thanks so much
for your help