Hi,
Try either of these free addins
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com
Cheers
Andy
excelcharter wrote:
> I'm trying to create a scatter chart with about 110 individually labeled
> data points. I've got the data in three consecutive columns with the
> name in the first column but I can't for the life of me figure out how
> to get excel to import the names from column A as the series name for
> the associated xy data in column B and C. Here's an diagram of my
> 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 a
> new series for each point?
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Bookmarks