Chart with x-axis as date/time
 

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

Chart with x-axis as date/time
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"UnderCoverGuy" wrote in message
...
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

Chart with x-axis as date/time
 

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