I want to track my son's racing progress but am not sure how. I have a header
row of Date, Racer1 time, Kart used, Racer2 time, Kart used. Each row is a
separate race (many times more than one race per day, if it matters) for each
driver. How do I crete a chart that will show a graph of their progress? I
would like the date on the left and the driver on top but I also would like
to see (separate chart maybe?) how each driver does depending on the Kart
used. I want to pull this from one worksheet (times) to another sheet,
(chart) in the same workbook.
Thanks in advance.
First, how do you want to display the results. I might display it using
something like a "Box and Whisker Plot" where the X axis could represent
Driver or Kart.
http://www.peltiertech.com/Excel/Charts/statscharts.html#BoxWhisker
> I want to track my son's racing progress but am not sure how. I have a header
> row of Date, Racer1 time, Kart used, Racer2 time, Kart used. Each row is a
[quoted text clipped - 5 lines]
> (chart) in the same workbook.
> Thanks in advance.
JohnT - 29 Nov 2004 18:09 GMT
Display as a line or histogram. But how do you start? I made a chart but am
unsure what to put where. Date on the X axis and driver/kart on the Y axis
would be cool...
> First, how do you want to display the results. I might display it using
> something like a "Box and Whisker Plot" where the X axis could represent
[quoted text clipped - 14 lines]
> > (chart) in the same workbook.
> > Thanks in advance.
Barb Reinhardt - 30 Nov 2004 16:17 GMT
Play around with the chart and if you have specific questions on how to do
it, come on back and ask some more questions.
> Display as a line or histogram. But how do you start? I made a chart but am
> unsure what to put where. Date on the X axis and driver/kart on the Y axis
[quoted text clipped - 18 lines]
> > > (chart) in the same workbook.
> > > Thanks in advance.