newbie chart question

  • Thread starter Thread starter retriever
  • Start date Start date
R

retriever

Sorry if this has been answered before, but I'm unsure of the term
under which I need to search :confused:

I have two colums of data that I'd like to produce a chart from. Eac
time I try to use the chart wizard, it insists on plotting each colum
on the same x-axis against a y-axis that is the row for each set o
data.

How do I force excel to give each column it's own axis and plot thes
against eachother? And is it possible to add a 'best fit line' on to
of the chart?

Many thanks,

Ro
 
from what I understand your question, you need x-y scatter chart(fifth in
the cahrt type list) and not line chart. try that.
 
Back
Top