To anyone who's keeping score, the limits are 32,000 points in a series and 256,000
points in the entire chart. I wish I didn't know that.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tushar Mehta wrote:

The only practical solution would be to create a XY Scatter chart.

For any other kind of chart, you can use John Mansfield's solution but
each time sample will be spaced equidistant from its neighbors.

The only other solution would be to create the correct spacing by hand.
The required interval must accomodate all the time values you have. I
wouldn't be surprised if the only such interval is 1 minute. So, if
that is indeed the smallest acceptable interval, create:
3/25 22:00
3/25 22:01
3/25 22:02
3/25 22:03
....you get the idea.

Only those rows that correspond to real data would have data values in
the other columns.

Assuming your data set fits in the limit for the number of data points
in an XL series (16,536 I believe) use a 'category' type for the x-axis
and you will get what you want.