Scatter graph point labelling

Question

Level 1

0 points

Scatter graph point labelling

Forgive me if this is the 1 millionth time this has been asked.

I am using iWork 9.0 and specifically Numbers, I want to create a scatter graph.

So a table looks like this:

A 100 120
B 120 100
C 100 100

I want to create a scattergraph with these points that each point is labelled A, B and C.

On other parts of this forum I have seen that you can create and XY and drop the pairs in, but I can't seem to get the labels dropped in. So can someone explain this to be in simple terms (forgive me i have used Excel for years and have a little macro that does this for me).

Thanks in advance.

MacBookPro, Mac OS X (10.5.6)

Posted on May 1, 2009 12:05 PM

Reply

Answer 1

Badunit

Level 7

31,044 points

May 1, 2009 7:26 PM in response to IanHughes

It might be easiest to see a screen shot but I'll try to describe it with words. You can't get different labels on the three points if they are all in the same column, as they will all be of one series. You need the Y data in three different columns.

B2=100
B3=120

C1="A"
C2=120

D1="B"
D3=100

E1="C"
E2=100

Grab all the data B2:E3 and create a scatter chart. It'll look messed up at first because it plots the four columns as two sets of X-Y pairs. Where the data is highlighted on the table, click on the pinwheel and choose "share X values".

Another option, of course, is to drop text boxes near the points on your chart with A, B, and C in them.

Reply