Remember Me?

#1
 JohnT Posts: n/a
Chart newbie help, please, How to create

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.
#2
 Barb Reinhardt Posts: n/a

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/Cha...tml#BoxWhisker

"JohnT" wrote in message
...
I want to track my son's racing progress but am not sure how. I have a

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.

#3
 JohnT Posts: n/a

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

"Barb Reinhardt" wrote:

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/Cha...tml#BoxWhisker

"JohnT" wrote in message
...
I want to track my son's racing progress but am not sure how. I have a

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.

#4
 Barb Reinhardt Posts: n/a

Play around with the chart and if you have specific questions on how to do
it, come on back and ask some more questions.

"JohnT" wrote in message
...
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...

"Barb Reinhardt" wrote:

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/Cha...tml#BoxWhisker

"JohnT" wrote in message
...
I want to track my son's racing progress but am not sure how. I have a

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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM Alex St-Pierre Charts and Charting in Excel 1 November 28th 04 05:05 PM Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM SPYREN Charts and Charting in Excel 1 November 27th 04 12:49 PM

All times are GMT +1. The time now is 03:55 AM.