Automated Series for X,Y point diagrams
 

Hi!

I'm trying to do a diagram with 100 x,y points, each with
their own name. I have the x, y and name values in
seperate columns, but I can't get Excel to recognize them
as indiviudal series - this gives me a lot of manual work
clicking on each cell to assign it to the appropriate
series.

Does anybody know of a an automatic (or more efficient)
way around this?

Cheers

A

Automated Series for X,Y point diagrams
 

Hi Anders,

If I understand what you're saying correctly I would suggest putting all
the data into one series and then using my XY Chart Labeler add-in to apply
the names as data labels. You can download the XY Chart Labeler from my web
site shown below.

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

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Anders F" wrote in message
...
Hi!

I'm trying to do a diagram with 100 x,y points, each with
their own name. I have the x, y and name values in
seperate columns, but I can't get Excel to recognize them
as indiviudal series - this gives me a lot of manual work
clicking on each cell to assign it to the appropriate
series.

Does anybody know of a an automatic (or more efficient)
way around this?

Cheers

A