If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|