|
Answer» I am using Excel 2007.
I want to draw chart of data that is in dd:hh:mm:ss format.
But when I add those cells to chart not is shown on it.
I am using scatter/x,y chart.
I WONDER if Excel isn't recognising the dd:hh:mm:ss format. I didn't it in standard time-formats so I MADE custom format for it.
Or maybe Excel ANYWAY thinks that those cells are text, not time?
How could I make Excel to understand this data? Or how could I convert it to some other form that Excel could use?Did you already read this?
How to use dates and times in Excel
Article ID: 214094 - Last Review: September 18, 2011 - REVISION: 8.0
I THINK that came up when I was Googling for solution.
It doesn't seem to contain anything related to my problem.
|
