View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default plot 2 columns against each other

Well I wanted to use a line graph to represent the data. Is that possible?

"Darv" wrote:

Hi Andrew,

Go to the series section in the wizard. Make sure only one series
exists. In the options for that series, select your X axis values by
clicking in the x-axis values box and selecting the cells in your
sheet. Do the same for your y-axis values.

Are you using an XY scatter graph?

David

Andrew wrote:

I am having problems with plotting 2 seperate columns against each other. I
have one column of data that needs to be the X axis and one column of data
that needs to be on the Y axis and they need to be plotted against each
other, but when I try to create a chart, it will not let me plot these 2
columns against each other but merely as 2 different data series. Please
help.