Excel 08--means on a bar graph

Discussion in 'Mac Apps and Mac App Store' started by WasabiSam, Mar 20, 2009.

Most Liked Posts
  1. WasabiSam, Mar 20, 2009

    WasabiSam macrumors newbie

    Joined:
    Mar 20, 2009
    #1
    I'm trying to create a chart on excel 08 that for the following type of data:
    A X Y
    1 a 4
    1 b 5
    1 c 8
    2 d 4
    2 e 7
    2 f 6
    3 g 4
    3 h 7
    3 i 2

    The graph has column X on the X-axis and Y on the y-axis. Is there a way graph the means of the Y column for each of the groups in column A (1's, 2's, 3's)?
    Thanks so much.
    PS-I'm new to posting on these forums so forgive me if I'm not clear.
     
    share
    + Quote Reply
  2. MooneyFlyer, Mar 20, 2009

    MooneyFlyer macrumors 65816

    MooneyFlyer

    Joined:
    Nov 18, 2007
    Location:
    Boston
    #2
    I think you are going to have to make a separate column to calculate the average -- at least I'm unaware of other way to do it.

    Do you know the set in column A ahead of time (the 1-3's?) If so, you could do something where you build a new table that did something like this;

    A Avg
    ----------
    1 a
    2 b
    3 c
    4 d

    To get the average you could use:
    =SUMIF(ORIG_COL_A_SET,$A1, ORIG_COL_Y_SET) / COUNTIF(ORIG_COL_A_SET,$A1,ORIG_COL_Y_SET)

    where:
    - $A1 refers to the "1" above, $A2 would be "2"
    - ORIG_COL_A_SET refers to the data you listed in the original post
    - ORIG_COL_Y_SET refers to the data you listed in the original post

    Then graph that table.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page