Chart/graph question
 

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

Theo,

Most of Excel's charts are category charts -- equally spaced items, with
only the Y axis as a value axis. You need the XY Scatter chart type. That
gives you value axes for both X and Y. If it doesn't work correctly (it
depends on your data layout), use Source Data (Right click the chart to get
to that, and go to the Series tab). Make sure the X Values and Y Values
boxes are pointing to the correct cells for your data.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"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

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