excel charts not accepting date-time series in x axis
excel
Solution
if you are using a line chart, change to an XY scatter chart with lines instead; a date axis on a line chart will ignore the time portion
Problem
How to make excel accept the following as different data points on the x-axis. ``` Time Licenses Used 2013-07-09 11:34 512 2013-07-09 11:36 523 2013-07-09 11:40 621 2013-07-09 11:43 125 2013-07-10 09:30 526 2013-07-10 10:30 589 2013-07-10 11:30 546 2013-07-11 10:40 549 ``` Why does Excel charts club all the times on a date together, why cant it interpret it a different time entries?