Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 5th 08, 03:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 92
Default 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   Report Post  
Old March 5th 08, 04:24 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default 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   Report Post  
Old March 5th 08, 05:50 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
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


  #4   Report Post  
Old March 6th 08, 03:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Incorrectly Plotting Non-sequential Data Points [email protected] New Users to Excel 6 June 20th 07 11:29 PM
Free Software that Performs 3D XYZ Plotting w Excel Data? Scotty81 Excel Discussion (Misc queries) 0 January 30th 06 07:50 PM
Can I plot an equation in Excel instead of plotting data? raechickx Charts and Charting in Excel 3 September 21st 05 11:49 PM
Plotting data across columns John Sawyer Charts and Charting in Excel 1 July 18th 05 02:08 PM
Plotting data in Excel Dave Mac Charts and Charting in Excel 3 February 15th 05 03:54 AM


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017