Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2004

Tip: Looking for answers? Try searching our database.

Chart newbie help, please, How to create

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnT - 29 Nov 2004 17:09 GMT
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.
Barb Reinhardt - 29 Nov 2004 17:30 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.