View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
FloMM2 FloMM2 is offline
external usenet poster
 
Posts: 207
Default 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