Importing series labels from a column in a scatter plot

  • Thread starter Thread starter excelcharter
  • Start date Start date
E

excelcharter

I'm trying to create a scatter chart with about 110 individually labele
data points. I've got the data in three consecutive columns with th
name in the first column but I can't for the life of me figure out ho
to get excel to import the names from column A as the series name fo
the associated xy data in column B and C. Here's an diagram of m
problem.

A B C
Dogs 5 8
Cats 3 3
Mice 4 2
...

I want a point labeled "Dogs" at (5,8), "Cats" at (3,3), "Mice" (4,2
and so on.

Is there any shortcut here or am I going to have to manually create
new series for each point
 
Thanks Andy. Do you have any preference between the two? Do you know if
this gross omission by MS will be remedied in their next version of
Excel?
 
I personally use Rob's util. John's one does a lot more beside data labels.

No indication that the problem will disappear anytime soon :(
Thanks Andy. Do you have any preference between the two? Do you know if
this gross omission by MS will be remedied in their next version of
Excel?
Click to expand...
 
Back
Top