Chart with x-axis as date/time

[Guest]

I have a spreadsheet with dates in column A and times in column B (when data
was gathered). I have a chart using the x-axis for column A (date). How can
I also get the chart to display the time? Basically, right now the x-axis is
in the format 09/24/06 but I would like for it to be in the format 09/24/06
at 12:00 (or something like that). Can I use a custom number format that
pulls data from multiple spreadsheet columns?

Thanks in advance for any help,
UCG

 

[Jon Peltier]

Combine the date and time into a single column (Excel stores these numbers
as a whole number date and fractional number time). This is now valid
numerical data, which will work as you want in the chart.

- Jon

 

[Guest]

I was afraid that I would have to do that (was hoping to avoid it). But oh
well, the end result is accomplished...

Thanks,
UCG