Chart basics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chrys - 27 Jul 2005 11:15 GMT

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

Reply to this Message

Rob Bovey - 27 Jul 2005 16:46 GMT

>I have two columns of numbers and I want to chart column A (x axis)
>against
[quoted text clipped - 3 lines]
> 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.

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.

Signature

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

Reply to this Message