I have a table with diferent information with a column date.
I have create a PivotTable A from the table where a row is the date column and values are other columns. In this PivotTable A I can create a TimeLine with the date field
I have create a PivotTable B with the source is the PivotTable A. And I can't create a TimeLine because excel not recognize the column date how a date.
Hi I find the problem. The origen table have dates = blank, then excel dont use this column how a TimeLine. My problem now is how to do excel to convert BLANK to DATE. Thank you