I have a time series of values and corresponding dates, continous but not with equal interval. I have created the graph and chosen the "date" column as x-axis but it is not registered. I have set the cell-type as "date", but on the x axis it just put the line number correspondig to the value. Even the correct values are displayed when I open the "select data source", but they do not show on the x axis.
Best Answer
It appears you are using the wrong type of graph for what you want. It is treating the values as categories rather than a continuous variable. Use a scatter (XY) chart. You will need to format the X axis with a date format.