View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
UnderCoverGuy UnderCoverGuy is offline
external usenet poster
 
Posts: 5
Default 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