Mean Data in Bar charts

[bevpike]

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

 

[FloMM2]

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

 

[Jon Peltier]

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