Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 05:09 PM
JohnT
 
Posts: n/a
Default 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.
Thanks in advance.

  #2   Report Post  
Old November 29th 04, 05:30 PM
Barb Reinhardt
 
Posts: n/a
Default

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

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.



  #3   Report Post  
Old November 29th 04, 06:09 PM
JohnT
 
Posts: n/a
Default

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

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.




  #4   Report Post  
Old November 30th 04, 04:17 PM
Barb Reinhardt
 
Posts: n/a
Default

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

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.








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 1 November 29th 04 11:21 AM
Mail merge to a chart Alex St-Pierre Charts and Charting in Excel 1 November 28th 04 05:05 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM
Hiding or Displaying Series In a Chart SPYREN Charts and Charting in Excel 1 November 27th 04 12:49 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017