Pivot Table Challenged

All,

I am having difficulty creating a pivot chart from the attached workbook. On "sheet1" I created a quick and dirty chart plotting wheelspace temperatures (TTWS1AO, etc) populated from "Data" over time. This shows all the temperatures for a specific gas turbine I am monitoring. Unfortunately, it is too busy and hard to follow overlapping series of information. The "data" is rendered from an output program from my customer.

In an attempt to create a Pivot Chart, I copied the information from "data" and transposed it onto "Test", flipping the rows and columns. However, I cannot create and adequate chart.

My goal is to have a pivot chart show I can compare any select sets of data from "test" worksheet.