Chart/graph question

  • Thread starter Thread starter Theodore Bartley
  • Start date Start date
T

Theodore Bartley

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.
 
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
 
Back
Top