Mean Data in Bar charts
 

I posted earlier and received no responses so I will reword my question.

I have the following data:

col 1 col 2 col3
_________________
4 12 18
5 14 20
6 13 19

I would like to create a barchart that shows one vertical bar for each
column with the mean value (ie. col 1 mean =5, col2 m=14, col3 m=19).
Basically, my chart would have three vertical bars showing the mean values.

It seems the only way to do this is to calculate the mean in different cells
and then build the chart on that calculated data (ie. the derived means).

I would like to be able to build the chart on the actual data so I could add
a "Y error bar" indicating the standard deviation for each column.

Is this possible?

Thanks in advance.

Attila

Mean Data in Bar charts
 

bevpike,
First of all:
mean of col2 <14, =13
Tha t might help, with what you are seeing and what you expect to see.

"bevpike" wrote:

I posted earlier and received no responses so I will reword my question.

I have the following data:

col 1 col 2 col3
_________________
4 12 18
5 14 20
6 13 19

I would like to create a barchart that shows one vertical bar for each
column with the mean value (ie. col 1 mean =5, col2 m=14, col3 m=19).
Basically, my chart would have three vertical bars showing the mean values.

It seems the only way to do this is to calculate the mean in different cells
and then build the chart on that calculated data (ie. the derived means).

I would like to be able to build the chart on the actual data so I could add
a "Y error bar" indicating the standard deviation for each column.

Is this possible?

Thanks in advance.

Attila

Mean Data in Bar charts
 

Here's how I responded to your other post:

Why don't people like to do their own calculations? Enter two rows for
calculations, using AVERAGE() and STDEV():

col 1 col 2 col3
_________________
4 12 18
5 15 31
6 13 19
_________________
5 13.33 22.67 [mean]
1 1.53 7.23 [s.d.]

Plot the mean values in the chart, then double click the resulting series,
select the Y Error Bars tab, select Custom at the bottom, click in the (+)
box and select the range containing the calculated SD, and do the same for
the (-) box.

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

"bevpike" wrote in message
...
I posted earlier and received no responses so I will reword my question.

I have the following data:

col 1 col 2 col3
_________________
4 12 18
5 14 20
6 13 19

I would like to create a barchart that shows one vertical bar for each
column with the mean value (ie. col 1 mean =5, col2 m=14, col3 m=19).
Basically, my chart would have three vertical bars showing the mean
values.

It seems the only way to do this is to calculate the mean in different
cells
and then build the chart on that calculated data (ie. the derived means).

I would like to be able to build the chart on the actual data so I could
add
a "Y error bar" indicating the standard deviation for each column.

Is this possible?

Thanks in advance.

Attila