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
|