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.

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RaineeDays" wrote in message
...
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.

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

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RaineeDays" wrote in message
...
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.

On Tue, 1 Apr 2008, in microsoft.public.excel.charting,
RaineeDays said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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 B1:D1 in
my little table above) and the data (B5:D5), 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 (B6:D6), then click in the Custom
(-) box and select the same range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RaineeDays" wrote in message
...
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

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RaineeDays" wrote in message
...
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.

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 :)

"Jon Peltier" wrote:

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 B1:D1 in
my little table above) and the data (B5:D5), 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 (B6:D6), then click in the Custom
(-) box and select the same range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RaineeDays" wrote in message
...
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

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RaineeDays" wrote in message
...
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.