Ok, no problem, I found the answer in Google. You have to use X-Y scatter
type of plot.

Sorry, I should have tried there first.

Regards,
Theo


"Theodore Bartley" wrote in message
...
Hi,

Is Excel capable of drawing a graph? This is a very common requirement
with experimental data.

For example, I have data:

Value 1 Value 2
3.1 101
5.7 180
6.2 143
7.9 93
10.5 108
etc.

This data represents a single line graph. Value 1 is the x-values and
Value 2 is the y-values. It is a single function. Can Excel do this? It
seems to me that Excel insists on having equally spaced x-values, and
would treat this data as 2 data series, or at best one of the series could
be used as X labels.

Thanks,
Theo