Home 
Search 
Today's Posts 
#1




Plotting Y vs. X data in Excel
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 xaxis 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 
#2




Plotting Y vs. X data in Excel
Hi,
Worked for me when I selected cells in column C1 press the CTRL key and also select the cells in C3. Insert chart, xyscatter. C1 plotted along the xaxis and C3 along the yaxis. 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 xaxis 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 
#3




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, xyscatter. C1 plotted along the xaxis and C3 along the yaxis. 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 xaxis 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 
#4




Plotting Y vs. X data in Excel
You can make a line chart work the same way if you place a text label above
the Y value column and leave a blank cell above the column of X values. Select these header cells as part of the source data, then create the chart.  Jon  Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc.  http://PeltierTech.com _______ "Dale" wrote in message ... 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, xyscatter. C1 plotted along the xaxis and C3 along the yaxis. 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 xaxis 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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel Incorrectly Plotting Nonsequential Data Points  New Users to Excel  
Free Software that Performs 3D XYZ Plotting w Excel Data?  Excel Discussion (Misc queries)  
Can I plot an equation in Excel instead of plotting data?  Charts and Charting in Excel  
Plotting data across columns  Charts and Charting in Excel  
Plotting data in Excel  Charts and Charting in Excel 