TimeLine in a PivotTable from another PivotTable

Copper Contributor

Hi,

 

  • 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.

Some idea?

 

Thank you.

1 Reply
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