I have the following Excel 2000 data read in from a csv file. [] meaning one cell
[ ][BR_TOP]
[17/08/2003 10:00:00][0.006642863]
[17/08/2003 10:10:00][NAN]
ect
Currently the graph produced has BR_TOP as the title and only displays the date part of the first(I wish date and time) column along the x-axis.
If I change the first date value to [17/08/200310:00:00], note the lack of spaces, then that value is displayed crunched up on the x-axis but all the following date and time values are shown corectly.
What I want is
1. to be able to correctly name the graph without having to use any of the commands in Excel. The user should just highlight the imported csv values and press create graph. Is there a way to do this through csv?
2. for the date and time to be shown correctly, as in both parts showing on the x-axis, for all values.
Many thanks for any help received.
[ ][BR_TOP]
[17/08/2003 10:00:00][0.006642863]
[17/08/2003 10:10:00][NAN]
ect
Currently the graph produced has BR_TOP as the title and only displays the date part of the first(I wish date and time) column along the x-axis.
If I change the first date value to [17/08/200310:00:00], note the lack of spaces, then that value is displayed crunched up on the x-axis but all the following date and time values are shown corectly.
What I want is
1. to be able to correctly name the graph without having to use any of the commands in Excel. The user should just highlight the imported csv values and press create graph. Is there a way to do this through csv?
2. for the date and time to be shown correctly, as in both parts showing on the x-axis, for all values.
Many thanks for any help received.