Problems plotting x axis values

M

mike

Hi,
I have been trying to get this to work now for a couple of days and
still can't get it to plot the x-axis correctly. Maybe someone out here can
help me here is what I got. I want to plot a line with markers and I have
the following:
Data range =sheet2!$c$2:$e$406 (columns)
Serious 1 values: =sheet2!$n$2:$n$406
x axis labels =sheet2!$a$2:$b$406
The problem here it is not charting lots of the dates in the x-axis

date test1 test2 test3 test4 test5 test6 test7 test8 test9
test10 totals
3/3/04 1:00 a b
ab
2:00 x c
xc
3/3/04 11:00 does not plot this date and time
 

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