Chart basics

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns of numbers and I want to chart column A (x axis) against
column B (y axis). The chart function keeps putting both sets of data on the
one (x) axis and the office assistant is giving me the runaround. I expect
that this is probably a basic default problem but I'm new to this and my
brain is refusing to go any further. Please help.

Chrys
 
Chrys said:
I have two columns of numbers and I want to chart column A (x axis)
against
column B (y axis). The chart function keeps putting both sets of data on
the
one (x) axis and the office assistant is giving me the runaround. I expect
that this is probably a basic default problem but I'm new to this and my
brain is refusing to go any further. Please help.
Click to expand...

Hi Chrys,

Make sure the numbers in columns A and B are the only thing you have
selected, then click the Chart Wizard toolbar button and select the XY
(Scatter) chart type. Follow the wizard from there and you should get what
you're looking for.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 
Back
Top