Question about graphing four sets of data
 

So i have four columns of data. The first column contains just names.
I want the names to appear as the x-axis. The second column is slowest
time, the third is fastest time (in min) that each name ran. Time in
minutes will be on the y-axis. Up to now, it's pretty straight
forward. Just make a bar chart with the name data and time data and
there you go (two bars for each name). But I also have this fourth
column of data which is "Number of attempted tries" or simply sample
size. I want to place the sample size as a number on top of the bars.

Any ideas?


--
RawlinsCross
------------------------------------------------------------------------
RawlinsCross's Profile: http://www.excelforum.com/member.php...o&userid=30126
View this thread: http://www.excelforum.com/showthread...hreadid=498129

Question about graphing four sets of data
 

Here is a longish way:
Select chart
type = and poiny to cell with first lable value (top of 4th column)
this makes a text box which you can drag to the top of a column
repleat with other lables
beat wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RawlinsCross"
wrote in message
...

So i have four columns of data. The first column contains just names.
I want the names to appear as the x-axis. The second column is slowest
time, the third is fastest time (in min) that each name ran. Time in
minutes will be on the y-axis. Up to now, it's pretty straight
forward. Just make a bar chart with the name data and time data and
there you go (two bars for each name). But I also have this fourth
column of data which is "Number of attempted tries" or simply sample
size. I want to place the sample size as a number on top of the bars.

Any ideas?


--
RawlinsCross
------------------------------------------------------------------------
RawlinsCross's Profile:
http://www.excelforum.com/member.php...o&userid=30126
View this thread: http://www.excelforum.com/showthread...hreadid=498129

Question about graphing four sets of data
 

Yep, that works and updates nicely. The only thing I can see the least
bit ardous is that you have to reposition the number if you want it
staright over the highest of the two bars as more data comes in. But
that's a small problem. Thanks for your help.


--
RawlinsCross
------------------------------------------------------------------------
RawlinsCross's Profile: http://www.excelforum.com/member.php...o&userid=30126
View this thread: http://www.excelforum.com/showthread...hreadid=498129