Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help building chart to track trends between two different sets of data | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
data fill question | Excel Worksheet Functions | |||
Excel graphs - two data sets on the same y-axis? | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) |