Thread: using date & time in the x axis of a graph

Originally Posted by sjhonny

i have a graph that uses date in its X axis. i want the axis to display date & time. i changed the source data cells' formatting to date & time, but the graph remains date only.
i tried defining the graph's format as date & time as well (thus canceling 'link to data'), but it's displayed as 00:00, no matter what time is displayed in the source data cell.
also, whatever i do, two X values which have the same date (but not the same time) always show in the graph as having the same date & time.
ideas anybody?
thanks in advanced.

Hi,

format the cells from which hte category axis is drawn to Time, and the category access to Custom, date & hh:mm


hth
---