ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart newbie help, please, How to create (https://www.excelbanter.com/charts-charting-excel/25-chart-newbie-help-please-how-create.html)

JohnT

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.

Barb Reinhardt

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.




JohnT

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.





Barb Reinhardt

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.








All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com