chart

[Pass-the-reality]

I have a spreadsheet with the below data. I am trying to create a line chart
that will track the times for each date. On my X axis, I want it to show
value 2-15 than 2-15 and then 3-16.

100 BK 01:03.7 2/15/08
100 BK 01:05.4 2/15/08
100 BK 01:05.4 3/16/08

 

[ShaneDevenshire]

Hi,

Select the Date and the Time ranges and click the chart wizard, choose Line
and click Next. Select the Series tab. Delete the series that represents
the Dates. Click in theCategory (X) axis labels box and then highlight the
range containing the dates and hit Finish.

With the chart select choose Chart, Chart Options, Axis tab and select
Category.

I notice that two of you dates are the same? is that really what you want
for a line chart? Also you might want to see the difference between the
Category choice above and the Time-scale options.