Automated Series for X,Y point diagrams

A

Anders F

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
 
R

Rob Bovey

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 *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automated Series for X,Y point diagrams 1
problem with scatter diagram excel 2007 2
x-y scatter plots and trend lines 0
Specifying a point on each series in an X-Y scatter graph. 1
Creating Multiple-Series Charts with as few steps as possible 3
Bar Chart With Custom Labels On X and Y? 2
grep X>Y>..>Z format on word documents 1
Is there a property to get the values for a point in a chart series? 6

Top