I am not sure i got across my point properly. The pivot table is making all the dates one date on the left of the column shown in the image. If I try to make a line chart from this pivot table i get the chart shown in the image. I wanted to have a line chart with the date at the bottom and the delayed min for each date plotted across the chart.
i have attached an updated excel doc with out the previous chart which may have caused some confusion.
Bookmarks