View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
PeterS
 
Posts: n/a
Default Excel Charts X Axis values as dd/mm/yy hh:mm

I have a table with readings taken at irregular intervals.
I want the data points to be plotted along a continuous axis but when I try
to do this all the data appears against the date only and the time is ignored.
I have tried setting the x axis as time series but this doesn't work.
I can't change the units to anything but days.
Can anyone suggest a solution.
TIA
PeterS