Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula question | Excel Worksheet Functions | |||
VBA Form Combo Box question. | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
basic pie chart question | Charts and Charting in Excel | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |