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.