Scatter Chart, Please Help!

G

Guest

I am trying to chart what should be very easy but it won't come out right. I
need a scatter chart on the following information:

TIME AGE
3:15 10
6:00 14
6:00 14
6:53 0.25
7:00 10
7:50 10
8:00 14
8:05 8
9:35 14
10:10 15
11:22 0.25
12:10 14
19:30 4
19:35 14
19:42 14
19:50 13

The result I get is nothing like I think it should be. Any help woudl be
appreciated. Using 03.
 
B

Barb Reinhardt

Select everything from TIME to the end of the data range.
Click on the chart wizard and select XY SCATTER
Ensure the series is in COLUMNS.

Try that.
 
G

Guest

What is coming out wrong?

have you checked to see that your times are actually times and not text?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top