Help charting csv sensor data ~65k rows

[caffine_junkie]

Hi everyone,

I am hoping someone can help me out? I have a csv file which I open in Excel 2003.

It contains data from 16 sensors (Humidity1 to Humidity16) in col a, date/time in col b and the sensor reading value in col c.

This data is 65536 rows long.

How do I automate (a macro or button) arranging each sensor with its date and time and variable so that it can be charted on the same line chart showing all 16 variables?

I have tried using auto filters and this takes me a large amount of time daily. I need to speed this process up and make it easy to use for anyone opening a file of this type.

Thanks in advance, and I hope my explanation is clear enough.

ATB

Paul.