Chart with x-axis as date/time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top