Excel 08--means on a bar graph

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

1. 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.

2. MooneyFlyer macrumors 65816

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.