Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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, 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Incorrectly Plotting Non-sequential 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 |