R
retriever
Sorry if this has been answered before, but I'm unsure of the term
under which I need to search
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
under which I need to search
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