View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Dale Dale is offline
external usenet poster
 
Posts: 92
Default Plotting Y vs. X data in Excel

Hi:
Scatter worked for me too.
I think the problem may have been that initially, I had a "line chart"
selected.

DaleB

"Andy Pope" wrote:

Hi,

Worked for me when I selected cells in column C1 press the CTRL key and also
select the cells in C3.
Insert chart, xy-scatter. C1 plotted along the x-axis and C3 along the
y-axis.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dale" wrote in message
...
Hi:
I am having trouble setiing up a chart/graph plotting one paramater
against
another. I am using Excel 2003 (Office).
Assume that I have 3 columns of data: C1, C2, and C3. (C2 dat is notr
used.)
Say that I want to plot a graph of C3 data vs. C1 data...i.e.,
data from C3 plotted along the vertical axis, and data from C1
plotted along the horizontal axis. How do I go about doing this?
I keep getting two lines plotted againts a common x-axis with
values {1,2,3...n} that have no meaning to me, other than they
represent the data point numbers, not their values.

Thank you...
DaleB