Problem with chart when time spans midnight

Hi Everybody!

This is probably an easy problem, but i have never worked with this kind of data before, and in this format.

I have recently come across a problem in a project that im involved in. We are monitoring pressures in an industri and we log this every second over a long period(about 12-18h, sometimes 60h+). Yes i know that the maximum amount of rows in Excel 2003 is 65k, but i have cut them down so that they only span max 64000 rows.

Up to now i have only made charts which are in the same day, for instance (24h format) 10:00-22:00.

But now im running into a problem when im trying to span between:

From: 2010-07-22 15:00

To: 2010-07-23 09:00

I can create the chart, but it stops the chart at midnight.
See attached files.

Im using the "Line chart" function.

How should i proceed to make it span midnight?

Best Regards
Andreas, Sweden

You can't have more than 32,000 points in a data series (It's nothing to do with midnight, 3 o'clock + 32,000 seconds = 23:53)
http://office.microsoft.com/en-us/ex...005199291.aspx
Sorry, try gnuplot