Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

WasabiSam

macrumors newbie
Original poster
Mar 20, 2009
1
0
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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.