Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charts - Align value & category data labels independently | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Charts don't update when data changes | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |